Without using array formulas:

=COUNT(A:A)-COUNTIF(A:A,"<18")-COUNTIF(A:A,"21")

Etc.

__________________________________________________ ____________________



"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:73c2604b4198a@uwe...
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