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