Count ages 0-5,6-10 ect
 

I need a formula to calculate how many clients are between ages 0-5 and 6-10
ect.

Count ages 0-5,6-10 ect
 

Give some details of how your data is laid out.

You can do this with COUNTIF, eg if your ages are in column B, then
you could have:

=COUNTIF(B:B,"<6")

to find out how many are under 6.

Hope this helps.

Pete

On Sep 18, 3:39*pm, Jessica wrote:
I need a formula to calculate how many clients are between ages 0-5 and 6-10
ect.

Count ages 0-5,6-10 ect
 

Assume client's age in A1:A100

0-5

=COUNTIF(A1:A100,"<=5")


6-10

=COUNTIF(A1:A100,"=6")-COUNTIF(A1:A100,"10")


--


Regards,


Peo Sjoblom

"Jessica" wrote in message
...
I need a formula to calculate how many clients are between ages 0-5 and
6-10
ect.

Count ages 0-5,6-10 ect
 

Why don't you post details of your data layout as you were asked to in your
previous post of the same question?

"Jessica" wrote:

I need a formula to calculate how many clients are between ages 0-5 and 6-10
ect.

Count ages 0-5,6-10 ect
 

Hello Jessica,

I suggest not to take COUNTIF but FREQUENCY.

Look into Excel help for further details...

Regards,
Bernd