Count the number between age ranges

[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

 

[Mike H]

Nigel < should be > for the subtraction bit

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

Mike

 

[Nigel]

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