Question: how to calculate weighted average return?
Answer: Divide SUM PRODUCT by SUM to get weighted average return. Return is defined as the gain or loss made on the principal amount of an investment and acts as an elementary measure of profitability.