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