Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif with 3 conditions
I have the following sheet (in Excel 2000)
year type province budget 2002 1 10 100 2002 1 10 150 2002 2 11 200 2003 2 11 250 2003 3 12 300 2003 3 12 350 to get the total budget per year+type+province I used =SUM(IF((A2:A7="2002")*(B2:B7="1")*(C2:C7="10");D2 :D7)). This formula is, with one extra argument, identical to the explanation in Help. However it returns 0 and not 250. Using the exact formula as stated in Help also returns 0. Note that I use ; instead of , due to the different thousand and decimal separator in continental Europe. A solution to this (simple?) problem is highly appreciated. |
#2
|
|||
|
|||
=SUM(IF((A2:A7=2002)*(B2:B7=1)*(C2:C7=10);D2:D7))
needs to be confirmed with control+shift+enter instead of just with enter. Moreover, no double quotes around numbers. Robbert wrote: I have the following sheet (in Excel 2000) year type province budget 2002 1 10 100 2002 1 10 150 2002 2 11 200 2003 2 11 250 2003 3 12 300 2003 3 12 350 to get the total budget per year+type+province I used =SUM(IF((A2:A7="2002")*(B2:B7="1")*(C2:C7="10");D2 :D7)). This formula is, with one extra argument, identical to the explanation in Help. However it returns 0 and not 250. Using the exact formula as stated in Help also returns 0. Note that I use ; instead of , due to the different thousand and decimal separator in continental Europe. A solution to this (simple?) problem is highly appreciated. |
#3
|
|||
|
|||
and replace the semi-colon with a comma.
|
#4
|
|||
|
|||
philc wrote:
and replace the semi-colon with a comma. Not on European systems, for example. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with two conditions | Excel Discussion (Misc queries) | |||
sumif with two conditions | Excel Worksheet Functions | |||
SumIF w/ two conditions (not the same as other posts!... I think) | Excel Discussion (Misc queries) | |||
SUMIF with two conditions ? | Excel Discussion (Misc queries) | |||
SUMIF based on 2 conditions | Excel Worksheet Functions |