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


  • AWESOME! Thank you!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️