Formula for counting age groups

  • Thread starter Thread starter techcs
  • Start date Start date
T

techcs

Hello all.
I'm a bit of a novice when it come to formulas and have been trying to
figure this out all day so I would really appreciate help sorting this
out.
I have a spreadsheet which contains ages from 18 to 85+ but I need it
to tell me how many of each group (18-64, 65-74, 75-84, 85+).
Please can anyone assist.

Thanks

Col
 
You can use

=COUNTIF(A2:A2000,">=18")-COUNTIF(A2:A2000,">64")

then


=COUNTIF(A2:A2000,">=65")-COUNTIF(A2:A2000,">74")


and


=COUNTIF(A2:A2000,">=75")-COUNTIF(A2:A2000,">84")


and finally


=COUNTIF(A2:A2000,">=85")



Another way might be using FREQUENCY


--


Regards,


Peo Sjoblom
 
You can use

=COUNTIF(A2:A2000,">=18")-COUNTIF(A2:A2000,">64")

then

=COUNTIF(A2:A2000,">=65")-COUNTIF(A2:A2000,">74")

and

=COUNTIF(A2:A2000,">=75")-COUNTIF(A2:A2000,">84")

and finally

=COUNTIF(A2:A2000,">=85")

Another way might be using FREQUENCY

--

Regards,

Peo Sjoblom






- Show quoted text -
Click to expand...

Speedy response.
Many many thanks, saved me a lot of work.

Col
 
Hi,

Suppose your data is in the range D1:D100

1. In three cells, say A1:A3, enter
64
74
84
2. Highlight the range B1:B4 (yes B4)
3. Type, but do not enter, the formula

=FREQUENCY(D1:D100,A1:A3)

4. Press Shift+Ctrl+Enter
 
Back
Top