Odd and even numbers
=SUMPRODUCT(--(MOD(A1:J1,2)=0),--(ISNUMBER(A1:J1)))
the "--ISNUMBER (A1:J1)" in your formula won't do any good. If one of the
cell contain text value, your formula still returns #VALUE! error.
The *array* formula below ignore any text value
=SUM(IF(ISNUMBER(A1:J1),IF(MOD(A1:J1,2)=1,1)))
*ctrl+shift+enter*, not just enter
"Peo Sjoblom" wrote:
For even numbers
=SUMPRODUCT(--(MOD(A1:J1,2)=0),--(ISNUMBER(A1:J1)))
for odd
=SUMPRODUCT(--(MOD(A1:J1,2)=1),--(ISNUMBER(A1:J1)))
--
Regards,
Peo Sjoblom
"RodJ" wrote in message
...
I need a function that would count how many are odd/even numbers in a row
or
column.
eg:
1,3,6,22,35 = this row has 3 odd and 2 even numbers. Is there a function
that can count this for me.
Thanks
RodJ
|