An average is the best way to get an insight of the data as a whole.

But sometimes average gives you biased value.

In those [almost every time] situations...

...the best way is to calculate the weighted average.

And I have found the best way is to use a formula by combining SUMPRODUCT and SUM functions.

This method is simple and easy to apply.

So today, in this post, I’d like to share with you how to calculate a weighted average in Excel using SUMPRODUCT and SUM.

Let’s get started.