As you will notice on attached sample.
I looking to count the total "ODD" and "EVEN" numbers using:
=SUMPRODUCT(--(MOD(A2:F2,2)=1)) for ODD
=SUMPRODUCT(--(MOD(A2:F2,2)=0)) for EVEN
The problem is when a cell is blank the coding counts the blank cell as a EVEN number.
Any suggestions on how to change the coding to not count "blank cells"??
Bookmarks