how to calculate weighted average yield of portfolio?
Divide SUMPRODUCT by SUM to get weighted average return A total of Rs 1.5 lakh is invested across asset classes (see screenshot). 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.