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 - [ Ссылка ]
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;
[ Ссылка ]
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
Ещё видео!