Weighted Average function

[shekala]

Is there a weighted average function in Excel? if not, any clever ideas
on how to create one?

 

[duane]

I am sure sumproduct would do it

 

[Peo Sjoblom]

Maybe

=SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)

with values in A and weights in B

--
Regards,

Peo Sjoblom

(No private emails please)

 

[hibernator]

An alternative way using "sum":
{=sum(A1:A10*B1:B10)/sum(B1:B10)}