count age over 65
=COUNTIF(rng,"65")

count age from 60 to 65
=SUM(COUNTIF(rng,{"=60","65"})*{1,-1})

count age from 55 to 60
=SUM(COUNTIF(rng,{"=55","60"})*{1,-1})


"James" wrote:

I have a column showing the ages of a number of people. I want to count the
number of people who a

Over 65
60 to 65
and 55 to 60

The countif formula I tried is not working. Thank you in advance for any help.

James