Hi All,

Thanks for the reply. I tried MartinW's method and it works. Appreciate
all your help very much.


Jez

"MartinW" wrote:

Hi,

Saved from a previous post,

This will count the EVENS
=SUMPRODUCT(--(A1:A10<""),--(MOD(A1:A10,2)=0))

And this the ODDS
=SUMPRODUCT(--(A1:A10<""),--(MOD(A1:A10,2)=1))

HTH
Martin


"Jezzy" wrote in message
...
Hi Hi,

I need help with a formula. I would like to count a column that consists
of
even and odd numbers eg. 28, 31, 43, 50, 60. I like to count how many
numbers in that column is odd or even.

I have tried the following but it didn't work

=countif(a1:a10,"1","3","5")

Appreciate some help here.

Thanks