adding values if the criteria in two columns are met

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
 
P

Pete_UK

Try this:

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

Adjust the ranges to suit your real data.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formular to Count values in cells of rows that meet criteria 7
another excel question, thanks guys! 4
I am trying to use the IF and SUMIF function on Excel 8
return values in the table with multiple conditions 3
3 criteria in an IF... 3
adding a 3rd criteria to an IF formula 4
List if criteria are met 4
lookup with two variables 2

Top