adding values if the criteria in two columns are met
 

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

adding values if the criteria in two columns are met
 

Try this:

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

Adjust the ranges to suit your real data.

Hope this helps.

Pete

On Feb 25, 12:36*am, Mayasmom
wrote:
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