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
|