countif??
 

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

countif??
 

Hi

See if this can help you:

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

Regards,
Per

"Liz" skrev i meddelelsen
...
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!!

countif??
 

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