Hello,
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!