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

Excel Tips & Tricks for Becoming a Pro

===============

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️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! :)

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

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy

[avangersamo]

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

[Marwelnajs]

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