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?