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