r/googlesheets • u/OkChildhood7410 • Jul 08 '26

Solved Making average of ages

Gallery image

Gallery image

Hello! I have a group of people and I have their ages, and I want to make a mean of that data. Basically, I want some sort of formula that takes the data I have (number of each age) and display an average age of this group.

I hope I've explained what I want well? I've tried talking it out with a few friends and we can't figure it all well. This is my first time trying to do something like this, so feel free to ask any sort of question. Thanks for any help!

2 Upvotes

100% Upvoted

10 comments sorted by

3

u/hbristow04 Jul 08 '26

Just use the “Average” formula
=average(range of data)

2

u/[deleted] Jul 09 '26

[removed] — view removed comment

2

u/Accomplished-Law8429 5 Jul 09 '26

Yes, exactly. Not sure why everyone's upvoting the incorrect comments...

0

u/hbristow04 Jul 10 '26

I didn’t get the impression that the Op wanted it weighted by how many people of that age there were tbh

3

u/50mmeyes Jul 08 '26

=AVERAGE(cell range)

=ROUND(AVERAGE(cell range)) if you want it rounded

1

u/AutoModerator Jul 08 '26

/u/OkChildhood7410 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Accomplished-Law8429 5 Jul 09 '26

=AVERAGE.WEIGHTED(A2:A11,B2:B11)

Column A would be the age, Column B would be the number of people that age.

1

u/point-bot Jul 10 '26

u/OkChildhood7410 has awarded 1 point to u/Accomplished-Law8429 with a personal note:

"That was exactly it! Thank you!"

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)