Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! . |
#3
|
|||
|
|||
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! . |
#4
|
|||
|
|||
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! . |
#5
|
|||
|
|||
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! . |
#6
|
|||
|
|||
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! . |
#7
|
|||
|
|||
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! . |
#8
|
|||
|
|||
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUMIF with two conditions ? | Excel Discussion (Misc queries) | |||
Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
SUMIF based on 2 conditions | Excel Worksheet Functions |