Remember Me?

#1
May 31st 05, 09:46 AM
 Robbert Posts: n/a
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 7)). 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
May 31st 05, 10:00 AM

=SUM(IF((A2:A7=2002)*(B2:B7=1)*(C2:C7=10);D27))

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 7)). 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
May 31st 05, 10:56 AM
 philc Posts: n/a

and replace the semi-colon with a comma.

#4
May 31st 05, 12:14 PM

philc wrote:
and replace the semi-colon with a comma.

Not on European systems, for example.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Fred Holmes Excel Discussion (Misc queries) 3 May 1st 05 10:10 PM ww Excel Worksheet Functions 3 March 31st 05 01:44 AM MeatLightning Excel Discussion (Misc queries) 7 February 8th 05 09:55 PM Mestrella31 Excel Discussion (Misc queries) 9 December 22nd 04 12:09 AM TimH Excel Worksheet Functions 3 October 28th 04 08:18 PM

All times are GMT +1. The time now is 08:09 PM.