A weighted average is one that takes into account the importance, or weight, of each value. This article will show you how to use Excel’s SUMPRODUCT and SUM functions individually and how to combine the two to calculate a weighted average.
A weighted average is an average that takes into account the importance, or weight, of each value. A good example would be calculating a student’s final grade based on their performance on a variety of different assignments and tests. Individual assignments usually don’t count as much towards a final grade as the final exam—things like quizzes, tests, and final exams will all have different weights. The weighted average is calculated as the sum of all of the values multiplied by their weights divided by the sum of all of the weights.