Try something like this:

For 18 through 21
=SUM(COUNTIF(A:A,{"<18","<=21"})*{-1,1})

For 22 through 31
=SUM(COUNTIF(A:A,{"<22","<=31"})*{-1,1})

For 32 through 41
=SUM(COUNTIF(A:A,{"<32","<=41"})*{-1,1})
etc.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"chedd via OfficeKB.com" wrote:

Hi

I have been task to find a formula to be able to count peoples ages into
select different age groups for a quartely report. The age groups i have to
catagories them into is 18-21 , 22- 31, 32-41, 42-51, 52 -61 year olds
The example is in column A, but my spreadsheet contains over 126 for each
month.

Age

16
24
45
50
23
60

Please can you help with a formula to help catorgries the aboe ages into the
allocated groups.

Your help would be most appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200706/1