We then divide the outcome of SUMPRODUCT by the SUM of the weights. Select cell C7 to make it the active cell this is the location where the students final mark will display. The SUMPRODUCT function multiplies each Tests score by its weight and then adds these resulting numbers.
As I said sumproduct is an easy way to calculate the weighted average or weighted mean in Excel.
You only calculate the average when the values in the data set count equally. The generic SUMPRODUCT weighted average formula is as follows. Suppose your teacher says The test. We then divide the outcome of SUMPRODUCT by the SUM of the weights.