Help with SUMPRODUCT formula

[tatizanon]

Hi,

I use LibreOffice 3 and I’m trying to use SUMPRODUCT in substitution to COUNTIFS, but I get #VALUE! error. I looked for other answers in similar questions and my formula appears to be ok, but I don’t know why I get error.

=SUMPRODUCT($Database.$AD$2:$AD$2800,"-",$Database.$AE$2:$AE$2800,“x”)

Can you help me?

Thanks,
Tatiana

[JohnSUN]

I think you mean

=SUMPRODUCT($Database.$AD$2:$AD$2800="-";$Database.$AE$2:$AE$2800="x")   

(not comma, but equal sign)

[L-user]

Don’t know what are you trying to accomplish, but sumproduct function is using two or more arrays that are multiplied. Sample: