View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jezzy Jezzy is offline
external usenet poster
 
Posts: 5
Default Countif function for Even and Odd numbers

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