Using the SUMIF Command
No matter How I arrange this formula, I keep getting this type of error #incorrect Argument Set. Can some one please let me know what I'm doing wrong
Best Answer
-
Sure. When trying to use SUMIF with more than one range/criterion, you need to change it to SUMIFS. The syntax is slightly different than SUMIF as well, in that you list the range you want to sum first, followed by criteria ranges/criteria.
SUMIFS(range you want to sum, criterion_range1, criterion1, [ criterion_range2, criterion2... ])
So for your formula:
=SUMIFS([Project Value]:[Project Value], [Task Completion]:[Task Completion], YEAR(@cell) = 2022, [Job Type]:[Job Type], "Service Call")
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Sure. When trying to use SUMIF with more than one range/criterion, you need to change it to SUMIFS. The syntax is slightly different than SUMIF as well, in that you list the range you want to sum first, followed by criteria ranges/criteria.
SUMIFS(range you want to sum, criterion_range1, criterion1, [ criterion_range2, criterion2... ])
So for your formula:
=SUMIFS([Project Value]:[Project Value], [Task Completion]:[Task Completion], YEAR(@cell) = 2022, [Job Type]:[Job Type], "Service Call")
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!
