[Excel 2007 Beta2] Function SUMIFS
 

I'm trying to use this new worksheet function, using the example provided
in the online help, but it doesn't work asbsolutely... The only way I
succeded was using it like a regular SUMIF...

I think it should be some bug in this function...

--

Ciao

Franz Verga from Italy

[Excel 2007 Beta2] Function SUMIFS
 

I put some numbers (1,2,3,4) in A1:A4
In B1:B4 I entered some letters (a,,b,c,d) and in C1:C4 some more letters
In D1 I entered =SUMIFS(A1:A4,B1:B4,"A",C1:C4,"D")
It gave me the correct answer; that is to say, the same value I get with
=SUMPRODUCT(--(B1:B4="A"),--(C1:C4="D"),A1:A4)
Tell us about your experiment
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Franz Verga" wrote in message
...
I'm trying to use this new worksheet function, using the example provided
in the online help, but it doesn't work asbsolutely... The only way I
succeded was using it like a regular SUMIF...

I think it should be some bug in this function...

--

Ciao

Franz Verga from Italy

[Excel 2007 Beta2] Function SUMIFS
 

I have just looked at the on-line example! What rubbish!
It states: Each cell in sum_range is summed only if all of the corresponding
criteria specified are true for that cell
But in =SUMIFS(B2:B5,A2:A5,"=Julie",A2:A5,"=Hans") , in any A cell we have
either JULIE or HANS so nothing ever gets added.
IMHO it is Help that is wrong; the function works as advertised (see my
first post)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Franz Verga" wrote in message
...
I'm trying to use this new worksheet function, using the example provided
in the online help, but it doesn't work asbsolutely... The only way I
succeded was using it like a regular SUMIF...

I think it should be some bug in this function...

--

Ciao

Franz Verga from Italy

[Excel 2007 Beta2] Function SUMIFS
 

Nel post
*Bernard Liengme* ha scritto:

I put some numbers (1,2,3,4) in A1:A4
In B1:B4 I entered some letters (a,,b,c,d) and in C1:C4 some more
letters In D1 I entered =SUMIFS(A1:A4,B1:B4,"A",C1:C4,"D")
It gave me the correct answer; that is to say, the same value I get
with =SUMPRODUCT(--(B1:B4="A"),--(C1:C4="D"),A1:A4)
Tell us about your experiment


I think I'll continue using the SUMPRODUCT version instead the new SUMIFS...
;-)


--
Ciao

Franz Verga from Italy