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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!