How to determine the values? - Microsoft Community

referring following online file, know on wrong sumproduct formula, should return 2 instead of 0.

have suggestions?
in advance suggestions

online file:

yes, press ctrl-shift-enter create array formula, still show 0 instead of 2.

seems there issue excel 2003 , iseven, use instead:

{=sumproduct(--if(iserror(mod(mid($a$2:$a$965,15,1),2)=0),0,mod(mid($a$2:$a$965,15,1),2)=0))}

andreas.

Office / Excel / Windows other / Older versions

Cororate