Autosum column values, if separate column values equal certain val
 

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

Autosum column values, if separate column values equal certain val
 

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.

--
Biff
Microsoft Excel MVP


"Hulqscout" wrote in message
...
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