Count the number between age ranges

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

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
 
Nigel < should be > for the subtraction bit

=COUNTIF(Replies!C5:C100,">=25")-COUNTIF(Replies!C5:C100,">=34")

Mike
 
Mike

Many thanks for your reply, I see what I have done wrong, just the swapping
of the greater and less than signs.

Much appreciated
 
Back
Top