Weighted Average with the SUMPRODUCT Function in Excel - Weighted Mean

In this video, we use the SUMPRODUCT function to calculate the weighted average of a range of values.

When calculating the average, all values are assumed to be equal.

However the weighted average, or weighted arithmetic mean, applies greater weight to some values more than others. This can often make more sense.

5 awesome uses of the SUMPRODUCT function -    • 5 Groovy SUMPRODUCT Function Examples  

In the video, we calculate the weighted average of a range of assessment scores for an individual. But some assessments hold a greater value than others.

The weighted average is found by multiplying each value by its weight, then summing the products and then dividing these totals by the sum of the weights.

This makes SUMPRODUCT the perfect function for the job, along with the SUM function also.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1