•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculating Average Age in a Pivot Table
I'm an Excel beginner and I have the following problem: I've created a pivot table from a database source. The rows contain the birthdates, and the values represent the number of customer numbers. That is, for each year, I have a specific number of customers.
I've already calculated the age by subtracting the birth year from the current year (2026; YEAR (NOW)).
The task is to calculate the average age of all customers.
My approach is to multiply the number of customers per year (e.g., 52 for the year 1972) by the age (here: 54) and then divide the sum of the column by the total number of customers.
How do I do this, and is this the correct approach?
I'm using the latest Excel version from M365.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#average age
#pivot table
#Excel
#birthdates
#customer numbers
#calculated age
#database source
#total number of customers
#correct approach
#current year
#multiply
#divide
#sum of the column
#Excel version
#M365