←Back to Beyond Market Intelligence
•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

Our take

Are you struggling to calculate the average age of your customers in a pivot table? You're not alone—many Excel beginners face this challenge. Fortunately, leveraging AI-powered tools can simplify your analysis and streamline your calculations. By effectively combining customer counts with their corresponding ages, you can derive the average age with precision. In this guide, we’ll walk through the correct approach to ensure your pivot table provides the insights you need. Let’s transform your data into meaningful information that drives better decisions!

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.

submitted by /u/KHE76187
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Related Articles

Tagged with

#rows.com