| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate cell row and column | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
