View Single Post
  #1   Report Post  
MeatLightning
 
Posts: n/a
Default 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!