Originally Posted by

**MeatLightning**
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!

> >.

> >

>

## Bookmarks