But what if some of the values have more 'weight' than others and consequently contribute more to the final average? In such situations, you'll need to calculate the weighted average.Īlthough Microsoft Excel doesn't provide a special weighted average function, it does have a couple of other functions that will prove useful in your calculations, as demonstrated in the formula examples that follow. In one of the previous articles, we discussed three essential functions for calculating average in Excel, which are very straightforward and easy-to-use. The tutorial demonstrates two easy ways to calculate weighted average in Excel - by using the SUM or SUMPRODUCT function.
