SUMIFS coming back unparseable
I'm trying to add up a total amount based on a column called 'Total Amount (USD)' and relate that total amount to a column called 'Region' but only if the column called 'Stage' is equal to "Proposed", or "Committed", or "Executing". Am I at all close to accomplishing what I'm trying to do with SUMIFS below?
=SUMIFS([Total Amount (USD)]:[TotalAmount (USD)], Region:Region,[Column33]50, OR([Stage]Stage ="Proposed", [Stage]Stage = "Committed", [Stage]Stage ="Executing"))
Best Answer
-
You aren't too far off. Give this a look...
=SUMIFS([Total Amount (USD)]:[TotalAmount (USD)], Region:Region, [Column33]50, Stage:Stage, OR(@cell = "Proposed", @cell = "Committed", @cell ="Executing"))
Answers
-
You aren't too far off. Give this a look...
=SUMIFS([Total Amount (USD)]:[TotalAmount (USD)], Region:Region, [Column33]50, Stage:Stage, OR(@cell = "Proposed", @cell = "Committed", @cell ="Executing"))
-
AWESOME! Thank you!
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!