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.

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 ***

Connect with us!

[marshallhughes]

I know this is coming late but thanks for the tutorial. I just got a request for weighted average of rates on one of my projects. This video helped me solve it much quicker.

[jingyiwang]

I have been assigned some tasks by one of my professors. And what you have shown and explained in the video is exactly what I need. Thanks for saving me as the deadline is approaching! Thank you so much!

[nishatjamil]

You're a saint, thank you so much

[ashwinrebbapragada]

This was extremely helpful. I really liked your presentation and explanation. Thank you for your time and service.

[alexrosen]

I use the weighted average allt the time as a business controller because it is often more relevant than the usual average in our business. The way you demonstrate it's use is much more efficient than my way so thank you! It really helps :-)

[blue-oceandreamer]

I studied and immediately applied in my work. Love it. Many thanks. :)

[susanlang]

Thank you so much. This was super important for us when it came down to my daughter’s grades. You made it all so clear. 🤓

[nelsoncheetube]

Love your teaching! simple and short. looking forward to more of your videos bro.

[eunicetosinibelli]

Super useful! You saved my afternoon! Thank

[angelinaseamster]

THANK YOU!!!! SO helpful. Appreciate it

[Mnoosh]

No need to divide by the sum of the weights because the weights are percentages.

[spoonman]

how to explain something in four minutes what my excel book tried to do with 15 pages: ^

[kaelzgaming]

Never thought I would meet Kuro here teaching us about weighted average 🤣🤣🤣

[bsnegi]

My problem for the weighted average of steel indices as shown in our agreement - like this : -
(iii) Adjustment for Steel Component
Price adjustment for increase or decrease in the cost of Steel procured
by the contractor under different schedules of BOQ shall be paid in
accordance with the following formula:
Formulae-I (for all schedules of BOQ except bill/schedule-2 B & 2
C):
Vs = Ps / 100 X RI X (S1-S0) / S0
Vs = Increase or decrease in the cost of work on the date under
consideration due to changes in the rates for Steel.
S0 = The weighted average of index Numbers of Wholesale
Prices in India by Groups and Sub Groups (Averages) for
(i) MS Bright Bars under Mild Steel -Long
Products sub-group (weight=1)
(ii) Angles, Channels, Sections, steel
(coated/not) under Mild Steel -Long Products
sub-group (weight=2)
(iii) Mild Steel - Flat products sub-group
(weight=1)
published in RBI (Reserve Bank of India) Bulletin / website of the
office of the Economic Adviser in the month on the day 28 days
prior to the closing date of submission of Bids.
S1 = The weighted average of index Numbers of Wholesale Prices
in India by Groups and Sub Groups (Averages) for
(i) MS Bright Bars under Mild Steel - Long Products subgroup
(weight=1)
(ii) Angles, Channels, Sections, steel (coated/not) under
Mild Steel - Long Products sub-group (weight=2)
(iii) Mild Steel - Flat products sub-group (weight=1)
published in RBI (Reserve Bank of India) Bulletin / website of the office
of the Economic Adviser in the month on the day 28 days prior to the
last day of the period to which a particular interim payment certificate is
related.
Ps = Percentage of Steel component of the work.
BASE DATE IS 25 MARCH'2019)

Hope you will understand it properly and will give proper solution that how to get "weighted average of MS Bright Bar, e-Mild Steel - flat product and Angle channels ..)
bs negi

[NikolaiWar]

Hey i wanna learn how to find price of something in different weight like example 1k of apple is 1$ but need to determine price of 300g using excel

[duelcard]

I use this all the time as a mine engineer to calculate copper grades.

[kseniyabezikova]

Character In the video It's great, I like it a lot $$

[gopalashetty]

Please make videos on Primavera P6 schedule development to till its completion for a project.

[noedelman]

How would you calculate weighted percentile scores? Can this be done?

[MoonLiteNite]

What if you have hidden cells? how do you doge those?