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