Autosum column values, if separate column values equal certain val

[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

 

[T. Valko]

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.