How to calculate weighted average in table?
Hi, I have a list of funds in a table in word which is populated from a back office system which means it can be 2 rows or 10 rows.
One column has the Fund Name, the second has the Value and the third has the Charge.
I have a total of the fund values purely being =SUM(ABOVE) but then the Charge needs to be a total weighted charge i.e. it needs to multiply each holding by the charge then add them all up and divide that charge by the overall value.
We are currently having to do this by putting it all into excel, creating another column that multiplies each fund value with the corresponding charge and then totaling this.
Is there a way in which this can be automated in the table? I have uploaded a trial document
|