#INCORRECT ARGUMENT SET

Options
AliT
AliT ✭✭
edited 02/08/23 in Formulas and Functions

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!