Odd and even numbers

[RodJ]

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

 

[Peo Sjoblom]

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]

Thanks Peo, i just tried your suggestion and did not work. Do I have to key
in _ _ between brackets?

Thanks heaps

 

[RodJ]

Thanks so much...it did work after i used --.
Wonderful . i really appreciate this....wow...what a great community...

 

[Teethless mama]

=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

 

[Ashish Mathur]

Hi,

Try this array formula (Ctrl+Shift+Enter)

=COUNT(IF((MOD(A1:E1,2)<>0),A1:E1))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Peo Sjoblom]

It will not count blank cells, that was the reason not to avoid text, or
else they will be counted as even (0)

--


Regards,


Peo Sjoblom