How To calculate Weighted Averages in Excel

In this video I explain how to calculate a weighted average in Excel.
The formula is very simple:

sumproduct(values_array,weights_array)/Sum(weights_array).

Let me know if you have any questions, comments or requests.
I'll try and upload the example video as soon as i can :)

[ckitt]

gosh, thank you. I didn't need all the other 15 minute videos to not give me the formula.

[jennaspier]

This video just saved my entire homework assignment! I could not figure out how to do this, no matter where I looked, including on the Microsoft support website! Thank you much for this video. You totally saved my grade!

[jimeverette]

This is exactly the way to show how to do a function. simple and fast. Great Job!

[Jacomko]

Subscribed, you Sir deserves the internet

[armani_chosen]

Thanks a lot, this really helped me in my six sigma project

[leahcopeland]

Just what I needed & straight to the point. Thanks!!!

[iztirabk]

Waow SimplyExcel well done, we need simple and easiest way as you did....

[tommunro]

Thanks, exactly what i was looking for.

[Robertpemz]

How it can be applied for rank weight for instance a value <=50

[uj]

Thanks.. its short and efficient formula :)

[wubayehualemu]

so how can i calculate weight average of soil nutrient in soil profile?

[elvindeleon]

Hi, what if one of the values intends to be low i.e. lower the better. For example, the second row in your example pertains to 'number of errors'. in that case the lower value you get the better. how do you calculate this in the weighted average together with all others that goes for higher numbers?

[Subweesh]

The weight i have is Percentage, how can i do it?

[rubenhuertagranados]

Good video, just what i want to know, not like other videos of 15 minutos to explain the same.
Thanks

[goldlionist]

Hi. Thanks for the video!
But, I have a simple doubt regarding ranges.

If instead of definite values, I had a range of values (income range), and the weights (% respondents within that range) were for the range, how could I find the weighted average in this case?

Thanks!

[lavanyaks]

How to add secondary axis in excel charts

[jasonspurlock]

Save rate 35% loyalty 35% voc 20% mob 20%. How would I find the balance score for these metrics ?

[tonystork]

This is supposed to work. I dunno why there is an error with my work when percentages are multiplied with whole numbers.

[guyfox]

When I highlight an array the function returns #NAME