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

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!

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

-----Original Message-----
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!
.

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

"Jason Morin" wrote:

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

-----Original Message-----
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!
.

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.


"MeatLightning" wrote:

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

"Jason Morin" wrote:

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

-----Original Message-----
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!
.

Hi

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


--
Regards
Roger Govier

"MeatLightning" wrote in message
...
here's my formula: =SUMPRODUCT(--(A4:A13="beef"),--(C4:C13="0"),B4:B13)
it returns: 0

"Jason Morin" wrote:

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

-----Original Message-----
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!
.

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.


--
Regards
Roger Govier
"Roger Govier" wrote in message
...
Hi

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


--
Regards
Roger Govier

"MeatLightning" wrote in message
...
here's my formula: =SUMPRODUCT(--(A4:A13="beef"),--(C4:C13="0"),B4:B13)
it returns: 0

"Jason Morin" wrote:

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

-----Original Message-----
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!
.

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

its really without quotation marks

"MeatLightning" wrote:

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

"Jason Morin" wrote:

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

-----Original Message-----
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!
.

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!

"alMandragor" wrote:

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

its really without quotation marks

"MeatLightning" wrote:

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

"Jason Morin" wrote:

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

-----Original Message-----
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!
.