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 ...

AttachmentSize
Book3.xlsx12.65 KB
Almir's picture

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.