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 - https://youtu.be/7j89BYcccU0 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 ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1