Weighted average

  • Thread starter Thread starter Kevin
  • Start date Start date
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.
 
Hi
try the following (column A contains the values and column B the
weights):
=SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)
 
Back
Top