SUMIF with additional parameter

On one sheet I show PO#, Total amount USD, and the status of Approval. On a different sheet, I want to add up the "Total Amount USD" for each PO, but only if the approval column is showing "Approved."

I know the right SUMIF formula: =SUMIF({PO}, [PO Number]@row, {Total Amount USD}) but I don't know how to add in the parameter to only add if {{Approval}} = "Approved"


Thanks in advance.



Best Answer

  • ShelbyWarren
    ShelbyWarren ✭✭✭✭✭
    edited 04/24/23 Answer ✓

    @JLen Sorry, I misunderstood the solution you were creating, try this:

    =SUMIFS({Total Amount USD}, {Approval}, "Approved", {PO #}, PO)

    The SUMIFS formula allows you to add additional criteria, such as the "Approved" status and the PO #.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!