Calculate the Weighted Average using the SUMPRODUCT Function

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 a 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. **FREE Instant download - 27 Awesome Excel Hacks - https://goo.gl/02ebSu Find more great free tutorials at; http://www.computergaga.com Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1