Weighted Average Question

James · Dec 19, 2003

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 · Dec 19, 2003

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