countif??

[Liz]

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!!

 

[Per Jessen]

Hi

See if this can help you:

=Countif(A1:A100;">=20)-Countif(a1:A100;">24")

Regards,
Per

 

[ker_01]

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