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

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