Why This SUMIFS Formula Doesn't Work?

Frank McGuire

I'm trying to identify how much Overall Projected Volume will Bill in the Year 2023 for Joe Smith. Not sure why this formula doesn't work?

=SUMIFS([Billing Year]:[Billing Year], "2023", [Overall Projected Volume]:[Overall Projected Volume], [Opportunity Owner]:[Opportunity Owner], "Joe Smith")

ericncarr

HI @Frank McGuire - The range you want to SUM needs to be the first thing in your formula in a SUMIFS formula.

=SUMIFS( [Overall Projected Volume]:[Overall Projected Volume], [Billing Year]:[Billing Year], "2023", [Opportunity Owner]:[Opportunity Owner], "Joe Smith")

Nick Korna

Hi @Frank McGuire,

In a SUMIFS formula, what you're trying to total should be the first part of the formula, followed by the criteria ranges & criteria. Your formula should look something like this:

=SUMIFS([Overall Projected Volume]:[Overall Projected Volume], [Billing Year]:[Billing Year], "2023", [Opportunity Owner]:[Opportunity Owner], "Joe Smith")

Hope this helps; if you've any questions etc. then just post! 😊

Frank McGuire

That works! Thank you!