Question: is sumproduct a weighted average?
Answer: We'll use the SUMPRODUCT and SUM functions to determine the Weighted Average. The SUMPRODUCT function multiplies each Test's score by its weight, and then, adds these resulting numbers. ... To get the Weighted Average, you divide by the Total of the weights.