SUMIFS coming back unparseable

Dennis Ruff

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"))

Paul Newcome

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"))

Paul Newcome

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"))

Dennis Ruff

AWESOME! Thank you!

Paul Newcome

Happy to help! 👍️