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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!