group by age range

J

jenn

I have a list of names with ages. I want to show the number of people that
are 0-7, 8, 13, and 14-17. Can I group by the ranges in a pivot table to
count the ranges?
 
B

Barb R.

Try using these equations
=COUNTIF(DATARANGE,"<=7")
=COUNTIF(DATARANGE,"=8")
=COUNTIF(DATARANGE,"=13")
=COUNT(DATARANGE)-COUNTIF(DATARANGE,"<14")-COUNTIF(DATARANGE,">17")
Barb Reinhardt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a line to a population bar chart 0
Make Y-axis values correspond to x- axis value 1
Display weeks from a Milestone 0
Project Start and End Date is not consistent 1
Countdown macro - display settings 2
Need Help on pivot table 1
UDF for Aging in excel - Help needed 15
VBA multiple list of values for variable 1

Top