View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nigel Nigel is offline
external usenet poster
 
Posts: 98
Default Count the number between age ranges

I have a spreadsheet (Replies) which contains ages in column C. I want to be
able to count all those who fall between certain bands/groups i.e. 25 - 34. I
have tried to use the following:
=COUNTIF(Replies!C5:C100,"=25")-COUNTIF(Replies!C5:C100,"<=34")
which I have obtained and modified from othert threads, but I don't get the
answers I expect.

Any help would be appreciated.

Thanks