=COUNTIF(A1:A21,"65")
=SUMPRODUCT((A1:A2160)*(A1:A21<65))
=SUMPRODUCT((A1:A21=55)*(A1:A21<=60))



"James" skrev:

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