Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif function
What is the syntax for sumif function with two criteria range and two criteria?
|
#2
|
|||
|
|||
Use a different function ... SumProduct().
=SumProduct((A1:A100=criteria1)*(B1:B100=criteria2 )*C1:C100) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "AHANG JJJ" <AHANG wrote in message ... What is the syntax for sumif function with two criteria range and two criteria? |
#3
|
|||
|
|||
SUMIF and COUNTIF allow for only one criterion. You need array formulas or
SUMPRODUCT if you have multiple criteria. See the other response for one way. On Fri, 30 Sep 2005 19:11:16 -0700, AHANG JJJ <AHANG wrote: What is the syntax for sumif function with two criteria range and two criteria? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function
I have something like this:
A B C D jim 4 jim 2 cathy 2 cathy 4 mary 5 mary 3 I would like to sum the values in B and D that corresponds to jim. I tried =sumproduct((criteria1)*(criteria2)*(range B,D)), but this doesn't work. Any help would be much appreciated. Thanks! "RagDyer" wrote: Use a different function ... SumProduct(). =SumProduct((A1:A100=criteria1)*(B1:B100=criteria2 )*C1:C100) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "AHANG JJJ" <AHANG wrote in message ... What is the syntax for sumif function with two criteria range and two criteria? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function
Try...
=SUMIF(A1:C3,"Jim",B1:D3) Hope this helps! In article , oomyoo wrote: I have something like this: A B C D jim 4 jim 2 cathy 2 cathy 4 mary 5 mary 3 I would like to sum the values in B and D that corresponds to jim. I tried =sumproduct((criteria1)*(criteria2)*(range B,D)), but this doesn't work. Any help would be much appreciated. Thanks! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function
nope, didn't work...
I should get a value of 6, but I'm only getting 4. Any other ideas? "Domenic" wrote: Try... =SUMIF(A1:C3,"Jim",B1:D3) Hope this helps! In article , oomyoo wrote: I have something like this: A B C D jim 4 jim 2 cathy 2 cathy 4 mary 5 mary 3 I would like to sum the values in B and D that corresponds to jim. I tried =sumproduct((criteria1)*(criteria2)*(range B,D)), but this doesn't work. Any help would be much appreciated. Thanks! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function
=SUMIF(A1:A3,"Jim",B1:B3) + SUMIF(C1:C3,"Jim",D1:D3)
HTH, Bernie MS Excel MVP "oomyoo" wrote in message ... nope, didn't work... I should get a value of 6, but I'm only getting 4. Any other ideas? "Domenic" wrote: Try... =SUMIF(A1:C3,"Jim",B1:D3) Hope this helps! In article , oomyoo wrote: I have something like this: A B C D jim 4 jim 2 cathy 2 cathy 4 mary 5 mary 3 I would like to sum the values in B and D that corresponds to jim. I tried =sumproduct((criteria1)*(criteria2)*(range B,D)), but this doesn't work. Any help would be much appreciated. Thanks! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function
i was thinking complicated instead of simple... thanks!
"Bernie Deitrick" wrote: =SUMIF(A1:A3,"Jim",B1:B3) + SUMIF(C1:C3,"Jim",D1:D3) HTH, Bernie MS Excel MVP "oomyoo" wrote in message ... nope, didn't work... I should get a value of 6, but I'm only getting 4. Any other ideas? "Domenic" wrote: Try... =SUMIF(A1:C3,"Jim",B1:D3) Hope this helps! In article , oomyoo wrote: I have something like this: A B C D jim 4 jim 2 cathy 2 cathy 4 mary 5 mary 3 I would like to sum the values in B and D that corresponds to jim. I tried =sumproduct((criteria1)*(criteria2)*(range B,D)), but this doesn't work. Any help would be much appreciated. Thanks! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function
The formula definitely returns the correct amount. Can you post the
exact formula you're using? In article , oomyoo wrote: nope, didn't work... I should get a value of 6, but I'm only getting 4. Any other ideas? "Domenic" wrote: Try... =SUMIF(A1:C3,"Jim",B1:D3) Hope this helps! In article , oomyoo wrote: I have something like this: A B C D jim 4 jim 2 cathy 2 cathy 4 mary 5 mary 3 I would like to sum the values in B and D that corresponds to jim. I tried =sumproduct((criteria1)*(criteria2)*(range B,D)), but this doesn't work. Any help would be much appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |