adding values if the criteria in two columns are met

  • Thread starter Thread starter Mayasmom
  • Start date Start date
M

Mayasmom

I need a formula to add values with two criteria in a column. I am trying
to add the values if two criteria are met. For example below, I want to add
the total of the amount that are for 2008 and has a Status of No. The answer
would be $86,750. I could use the Pivot Table, but It's not what I want to
use. Is there another way to do it with a formula?

Amount Percent Year Status
75,000 3.00% 2008 No
6,750 3.00% 2008 No
9,100.00 2.00% 2009 Yes
620,000 2.00% 2009 No
2,800 2.00% 2009 No

thank you,
mayasmom
 
Try this:

=SUMPRODUCT(--(C2:C10=2008),--(D2:D10="No"),A2:A10)

Adjust the ranges to suit your real data.

Hope this helps.

Pete
 
Back
Top