SUMIF with additional parameter

JLen

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.

ShelbyWarren

@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 #.