Weighted average

K

Kevin

Does anybody now what formula to use to calculate the
weighted average of a series of numbers.
I have a mutual fund statement that is so misleading I
need to try and show that the one area is not so
important as the overall fund performance.
Any help would be great.
 
F

Frank Kabel

Hi
try the following (column A contains the values and column B the
weights):
=SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)
 
Top