how to calculate weighted average in ms excel?
To get the Weighted Average, you divide by the Total of the weights. If we had just averaged the Test scores, the value would be 75.5, a significant difference. For more information about the SUMPRODUCT and SUM functions, see the course summary. Now, you have a good idea about how to average numbers in Excel.