Link to home
Start Free TrialLog in
Avatar of Star Gazr1
Star Gazr1Flag for United States of America

asked on

Excel 2010 Calculate Average from Groups of data

I have a sample output file attached that provides age categories and the different counts among the categories.
I want to calculate the overall average age (factoring in the overall counts in the categories as well),  from the sample data provided.  Any  ideas on how i can do this?  thanks for any info.
File.xls
SOLUTION
Avatar of Doug
Doug
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Star Gazr1

ASKER

Thanks for the info. I thought there might be a way doing a weighted average, based on the counts in each group
ASKER CERTIFIED SOLUTION
Avatar of Jerry Paladino
Jerry Paladino
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Jerry,

Thanks for the detailed explanation and also the sample file, I really appreciate it.
How do I close the question out?  Thanks
The Admin page for closing a question is here:  Close a Question
Should be a button on each comment and you pick the solution you feel best answered your question.   If the "Best Solution" buttons are not displaying then you may have to request attention from and Admin.  That button is in the bottom right corner of your original question.
Thanks for the help