Question: how to calculate weighted average with sumproduct?
Answer: We then divide the outcome of SUMPRODUCT by the SUM of the weights. And this returns the Weighted Average of 80. SUMPRODUCT is essentially the Sum of Test 1 times its weight, plus the Mid-term times its weight, and so on. To get the Weighted Average, you divide by the Total of the weights.