#INCORRECT ARGUMENT SET
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
-
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
-
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.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
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")
-
Thank you both! That did it!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!