Using the SUMIF Command

Doug_aftgp.com

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

Jeff Reisman

@Doug_aftgp.com

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")

Jeff Reisman

@Doug_aftgp.com

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")