group by age range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try using these equations
=COUNTIF(DATARANGE,"<=7")
=COUNTIF(DATARANGE,"=8")
=COUNTIF(DATARANGE,"=13")
=COUNT(DATARANGE)-COUNTIF(DATARANGE,"<14")-COUNTIF(DATARANGE,">17")
Barb Reinhardt
 
Back
Top