Hello,

Hmm, both versions should work quite fine.

Actually, JE's version even differentiates between upper case Y and
lower case y (which are NOT counted).

Explanations you can find here, for example:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards,
Bernd