# #INCORRECT ARGUMENT SET

Options
✭✭
edited 02/08/23

Good Morning,

I need to sum all executed contracts, but only summing the most recent record. I am using SUMIFS and my formula isn't working out.

=SUMIFS({Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4, "Y",{Sheet - Contract Management - Complete Lib Range 2})

Range 3 is my Status column, Range 4 is my Last Record column and Range 2 is my amount column.

Thanks in advance for any assistance.

## Best Answer

• ✭✭✭✭✭✭
Answer ✓
Options

Also missing a closing curly bracket after Range 4.

=SUMIFS({Sheet - Contract Management - Complete Lib Range 2},{Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4}, "Y")

## Answers

• ✭✭✭✭✭✭
edited 02/08/23
Options

If what you are trying to sum is the Range 2 amount column, that should be at the beginning of your formula.

=SUMIFS({Sheet - Contract Management - Complete Lib Range 2},{Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4}, "Y")

This will sum the values in the Amount column where your Status is Executed and the Last Record is Y.

If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

• ✭✭✭✭✭✭
Answer ✓
Options

Also missing a closing curly bracket after Range 4.

=SUMIFS({Sheet - Contract Management - Complete Lib Range 2},{Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4}, "Y")

• ✭✭
Options

Thank you both! That did it!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

Good catch, @Colleen Patterson as well seeing that order mix-up in the syntax.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!