Cat42

Can anyone help....

I have a long list of numbers on an Excel 2000 spreadsheet. What formula do I use to count up the number of odd and even numbers in the list?

Many thanks

ST.

Fosters

there's probably a slick way, but in a new column, do a formula on the first row:
=IF(MOD(A1,2)>0,A1,0)
and then dbl-click that down to the bottom of the data.
sum the new column
do the same in a new column for even numbers (mod(x,2)=0)

Cat42

Fosters,

I tried it but got some rather large figures come up so I just changed the 2nd A1 in the formula you gave to a 1 so odd numbers appear as 1's and even as 0's.

Now I just need put COUNTIF at the bottom to calculate how many 0's and 1's to give me the totals required.

Thanks for that mate.
Regards,
ST.

Fosters

D'Oh! thought you meant sum them - serves me right for hitting reply thinking "oo oo I know that".