How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT)

This video tutorial offers a quick and easy way how to calculate a weighted average in Excel. Weighted average is a calculation standardly used if the values for calculating an average have a varying degree of importance. For weighted average, the degree of importance for each value is taken into account. Just like in our example, where the score for each exam has a different weight.
Don’t miss out a great opportunity to learn:
How to Calculate an Average in Excel
► • How to Calculate an Av...
Excel Tips & Tricks for Becoming a Pro
► • How to Insert Image in...
===============
❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
RUclips ► www.youtube.com/@ExcelTutoria...
================
⏱️Timestamps⏱️
0:00 Intro
0:29 What is the Difference between Weighted and Regular Average
1:00 How to Calculate the Average in a Standard Way
1:28 How to Calculate the Weighted Average Using the SUMPRODUCT Function
================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)
► ruclips.net/user/ExcelTutori...
Transcription How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT)
► www.easyclickacademy.com/how-...
Got Microsoft Office 365? Get it here
► www.easyclickacademy.com/buy-...
Connect:
LinkedIn ► / easyclickacademy
Facebook ► / easyclickacademy
Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/34...
Voice over artist ► seanantonyvo.com
#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy

[@subramanirangasamy3320]

Superb very crisp 👌

[@ExcelTutorialsEasyClickAcademy]

Glad it was helpful! :)

[@avangersamo3585]

Please how are you changing voice in what app is someone app on mobile??

[@mohamed.montaser]

nice video, but u don't need to divide SUMPRODUCT by the sum of weights, this function as it is =SUMPRODUCT(C3:C5,D3:D5) will do the same output which is 74.2

[@AmeerBeresford]

what if one of the scores is a zero?

[@marvelnajs1065]

Wow najs

[@marvelnajs1065]

Ako sa maš viem že si Slovák lebo si o tom robil video

[@marvelnajs1065]

Ja som Slovák 😂😂😂

[@ExcelTutorialsEasyClickAcademy]

super, pozdravujem :)

[@newtasmr8964]

@@ExcelTutorialsEasyClickAcademy aj ja som slovak, inak super naucny kanal, budem nadalej sledovať😊