Hi,

Create yourself a table with the age groupings in which in my case is in
columns A1 & B1 down

0 10
11 20
21 30

The put this in C1 and drag down

=COUNTIF($A$1:$A$100,"="&B1)-COUNTIF($A$1:$A$100,""&C1)

Mike

"plally" wrote:

I have a column that includes a number representing attained age. There are
approximately 21,000 records. I need to find the distribution of ages in
increments of 10. i.e., the number of records betwen 0 and 10, 11 and 20, 21
and 30, etc.

I've tried using an if statement in the following format:
=IF(11<=D2<=20,1,0). If D2 (attained age) is = 11 and is less than 20, give
me 1 as the value, otherwise, return 0. The statement does not seem to be
working properly.

Thanks