Autosum column values, if separate column values equal certain val

  • Thread starter Thread starter Hulqscout
  • Start date Start date
H

Hulqscout

I an trying to set up a calculation subtotal for "Pending", "Approved" or
"Rejected" status of change orders items. Each change order row has a column
for status (E3-26) and a column for amount (H3-26). The 'pending' subtotal
would only total the amounts with the "Pending" status. Each status type
would have a separate subtotal.

How would I set this up? I am using Excel 2003
 
Try this:

=SUMIF(E3:E26,"pending",H3:H26)

Or, use a cell to hold the criteria:

A1 = pending

=SUMIF(E3:E26,A1,H3:H26)

Do the same for each category of status.
 
Back
Top