SumIF w/ two conditions (not the same as other posts!... I think)

M

MeatLightning

Ok, I'm trying to find the value of items within a column that meet two
criteria.

For example:

Col A contains type (either "beef" or "cheese" or "Lemons")
Col B contains cost (number)
Col C contains grade (0,1,2)

I want to add up the total cost of all the grade 0 beef.

I tried the sumproduct thing and I couldn't get it to work.

any help would be much appreciated!
 
J

Jason Morin

There could be several reasons why the formula is not
returning the correct value. Post your SUMPRODUCT formula
and the value it is returning along with the value it
*should* return.

HTH
Jason
Atlanta, GA
 
M

MeatLightning

here's my formula: =SUMPRODUCT(--(A4:A13="beef"),--(C4:C13="0"),B4:B13)
it returns: 0
 
P

Paul Hollinger

Try it without the quotes around 0 (i.e., C4:C13=0). You are checking for a
text 0, and column C probably contains numeric values.
 
R

Roger Govier

Paul is quite right, the quotes around the 0 are not necessary if the values
in column C are numeric.
SUMPRODUCT(--(A4:A13="beef")*(C4:C13=0)*B4:B13) should give the answer you
are looking for.
 
A

alMandragor

SUMPRODUCT((A4:A13="beef")*(C4:C13=0)*B4:B13)

its really without quotation marks
 
M

MeatLightning

Thanks all!

Here's the one that did the trick:
=SUMPRODUCT(--(A4:A13="beef"),--(C4:C13=0),B4:B13)

I just had to get rid of the quotes... DUH!

thanks again!
 
Top