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

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

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

Thanks heaps
--
RodJ


"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

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


"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

=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

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

"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

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

"Teethless mama" wrote in message
...
=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