J
Jessica
I need a formula to calculate how many clients are between ages 0-5 and 6-10
ect.
ect.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
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
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
P
Peo Sjoblom
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
0-5
=COUNTIF(A1:A100,"<=5")
6-10
=COUNTIF(A1:A100,">=6")-COUNTIF(A1:A100,">10")
--
Regards,
Peo Sjoblom
M
Mike H
Why don't you post details of your data layout as you were asked to in your
previous post of the same question?
previous post of the same question?
B
Bernd P
Hello Jessica,
I suggest not to take COUNTIF but FREQUENCY.
Look into Excel help for further details...
Regards,
Bernd
I suggest not to take COUNTIF but FREQUENCY.
Look into Excel help for further details...
Regards,
Bernd