Assuming all of your ages were in column A, rows 1-100

=Sumproduct((A1:A100=0)*1,(A1:A100<20)*1)
=Sumproduct((A1:A100=20)*1,(A1:A100<25)*1)
etc.

HTH,
Keith


"Liz" wrote:

i have a list of peoples ages.. i need a formulat that tells me how many
people are aged from 0-19, 20-24, 24-25 etc. im using countif but i cant
figure out how to make it work. also i need to include 20 and 24 for example.
please help!!