ExcelBanter - group by age range

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - group by age range (https://www.excelbanter.com/charts-charting-excel/26535-group-age-range.html)

jenn

group by age range

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?

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

"jenn" wrote:

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?

All times are GMT +1. The time now is 03:29 AM.