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?