How to get weighted Average ?
Hi,
I want to get weighted average of supervisor's AHT without using "Sum Product Formula"
Data is in attacted Format.
Kindly help me ...
Attachment | Size |
---|---|
Book3.xlsx | 12.65 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 510 guests online.
New Excel Experts
Current Excel / VBA Jobs |
How to get weighted Average ?Hi, I want to get weighted average of supervisor's AHT without using "Sum Product Formula" Kindly help me ...
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
What is calculation?
In final sheet you named cell "Average". I think weighted average is different than average. I am not sure what you need exactly. If you need average only, you can get it creating pivot table and summary field of Average instead of sum. In another hand, if you need "real" weighting, you should calculate it for each row (in a new column), and then summarize it by supervisor.