Question: how to calculate weighted average return in excel?
Answer: Divide SUMPRODUCT by SUM to get weighted average return The SUMPRODUCT function gives a value of Rs 4,770, which is the net amount earned from the portfolio, given the amount invested and returns. The sum function calculates the total amount of investments, which is Rs 1.5 lakh.