Help with match function, i need to tally
 

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

Help with match function, i need to tally
 

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

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.
--
Gary''s Student - gsnu200784


"Adam" wrote:

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