Excel 2007 : Conditional Addition

I have two columns; we will say they are columns “A” & “B”. Both columns contain dollar amounts. I need to sum up all of the cells in column A but only if their adjacent cells in column B contain a certain character, in this case it is a “0” or in accounting terms (-). I need to repeat this conditional formatting but this time sum up all of the cells in column A only if their adjacent cells in column B match. What is the best method to accomplish this?

You should be able to use SUMIF for the first, e.g.

=SUMIF(A:A,0,B:B)

For the second try

=SUMPRODUCT(--(A1:A100=B1:B100),A1:A100)

Note the first formula allows you to refer to the whole column, the second doesn't

When I use your first formula, I get $0.00 dollars, which is not correct. Please refer to the screenshot for the following. Take H785 & I785 the amount is $3.32 in column H but $0.00 in column I, therefore I would like to add $3.32 to H787 ($268.00) because H787's corresponding cell (I787) is also $0.00 and so on... I just need to add PO's that have not been paid for which is the $0.00 amount in column I

Thanks for your help!

The formula given should do it, adjusted to your columns

=SUMIF(H:H,0,I:I)

Do you know why I get $0.00 then...something has to be wrong. Here is my equation: =SUMIF(H3:H848,0,I3:I848)

From your initial description, it sounds like you need to change the formula to =SUMIF(I3:I848,0,H3:H848).