View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default COUNTIF Function

Hi, I'm having a few problems with the COUNTIF function. This is what I'm
looking for.

Range is A40:A70. This contains numbers between 0 and 21.

Then I have columns B,C,D
In columnB I would like to have COUNTIF(A40:A70, odd number) (So count all
odd number's in the range except for 0)
In columnC I would like to have COUNTIF(A40:A70, 12 AND <21) (So count all
numbers between 12 and 21)
In columnD I would like to have COUNTIF(A40:A70, 1,4,7,13,19) (So count all
numbers I've requested)

Hope this makes sense. I'm sure it's something simple, but I can't figure
it out.
Thanks again!
Matt