You can calculate a weighted average as

=SUMPRODUCT(weights,numbers)/SUM(weights)

I haven't a clue what you mean by "the mathematical way of 'means'"

Jerry

Aloysicus wrote:

This is the example data that I have

Day1 Day 2
Day 3 Day 4
Calls 50 100
150 200
AHT 200 200 200
200

Day 1 Day 2
Day 3 Day 4
Calls 75 80
90 100
AHT 100 100
100 100


Is there a way to do weighted average without using the mathematical way of
'means'?