Nigel < should be for the subtraction bit

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

Mike

"Nigel" wrote:

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