Help with match function, i need to tally

[Adam]

Ok, I have thousands of rows of data. One of the columns is titled "age" and
each row has a different age. Ranging from 15-100. I need to tally these
rows into age group, 0-18, 19-30, 30-50 etc etc.

Is there a code i can run that will tally these for me?

Thanks,

-Adam

 

[Gary''s Student]

Let's say the data is in column A and the groups are:

15 - 30
31 - 77
78 - 100

In B1 thru B3 enter:

=COUNTIF(A:A,"<31")
=COUNTIF(A:A,"<78")-B1
=COUNT(A:A)-B1-B2


adapt these formula to match your specific groupings.