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.