SUMIFS formula returning #INCORRECT ARGUMENT SET: order of Range & Criteria?

Amanda Chu
Amanda Chu ✭✭
edited 06/11/20 in Formulas and Functions


I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message.

=SUMIFS({MH Client Profiles v2 Range 13}, "East", {MH Client Profiles v2 Range 16}, 1, {MH Client Profiles v2 Range 3})

All I want is to validate that the Region column has "East" and the Terminated column is "checked" and then add up the Revenue column.

Any advice would be appreciated. 

Thank you!

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!