Why This SUMIFS Formula Doesn't Work?
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")
Answers
-
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")
-
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! 😊
-
That works! Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!