J Jessica Sep 18, 2008 #1 I need a formula to calculate how many clients are between ages 0-5 and 6-10 ect.
P Pete_UK Sep 18, 2008 #2 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
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
P Peo Sjoblom Sep 18, 2008 #3 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
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
M Mike H Sep 18, 2008 #4 Why don't you post details of your data layout as you were asked to in your previous post of the same question?
Why don't you post details of your data layout as you were asked to in your previous post of the same question?
B Bernd P Sep 18, 2008 #5 Hello Jessica, I suggest not to take COUNTIF but FREQUENCY. Look into Excel help for further details... Regards, Bernd
Hello Jessica, I suggest not to take COUNTIF but FREQUENCY. Look into Excel help for further details... Regards, Bernd
