ExcelBanter - Weighted Average Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Weighted Average Question (https://www.excelbanter.com/excel-programming/285865-weighted-average-question.html)

James[_17_]

Weighted Average Question

It is easy enough to find simple average with =average(a1:a100)

What is the easiest way to find a average?

Thanks

James

Tom Ogilvy

Weighted Average Question

assume the weights are in B1:B100
=sumproduct(A1:A100,B1:B100)/sum(B1:B100)

--
Regards,
Tom Ogilvy

"James" wrote in message
. ..
It is easy enough to find simple average with =average(a1:a100)

What is the easiest way to find a average?

Thanks

James

All times are GMT +1. The time now is 11:49 PM.