Example: Row A1=0, B1=7, C1=4, D1=0. In cell E1=3, it should be 1. Count even numbers.
I used this formula {=SUM(1*(MOD(A1:D1,2)=0))} to count all the even numbers in an array.
I am aware that 0 is considered an even number BUT I do not want to include the zeros in an array.
I used this formula {=SUM(1*(MOD(A1:D1,2)=0))} to count all the even numbers in an array.
I am aware that 0 is considered an even number BUT I do not want to include the zeros in an array.