Help with SUMPRODUCT formula


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.


Can you help me?


I think you mean


(not comma, but equal sign)

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

image description