How to group ages in excel pivot table
- age range formula in excel
- age range calculation in excel
- age group formula in excel from date of birth
- age group calculation in excel
Pivot table age range
How to group age range in google sheets.
Often you may want to group data based on age range in Excel.
Fortunately this is easy to do by using the Group function within an Excel pivot table.
The following example shows how to create the following pivot table in Excel that groups basketball players on based on age ranges:
Example: How to Group Data by Age Range in Excel
Suppose we have the following dataset in Excel that shows the points scored by basketball players on various teams:
Suppose we would like to calculate the sum of points scored by the basketball players based on the following age groups:
To do so, we can first create a pivot table by highlighting the cell range A1:C11, then clicking the Insert tab along the top ribbon, then clicking the PivotTable icon:
In the new window that appears, we will choose to place the pivot table in the Existing Worksheet in cell E1, then click OK:
In the PivotTable Fields panel that appears on the right side of the screen, drag Age into the Rows box and Points into the Values box:
The pivot table will be populated with the follo
- formula to calculate age range in excel
- how to group age range in excel formula