In this tutorial, I'm going to show you how to calculate a weighted average in Microsoft Excel with percentages. The weighted average is similar to the standard arithmetic average, except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.

ONLINE GUIDE
[ Ссылка ]

VIDEO CHAPTERS
00:00 Intro
00:15 My example data
00:57 Calculating the average
01:40 Step 1 - Multiply the score by weight
02:13 Step 2 - Sum these values
02:29 Step 3 - Divide by the sum of the weights
03:33 Calculate weighted average with the SUMPRODUCT function
04:27 Wrapping up

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor [ Ссылка ]
YouTube SEO [ Ссылка ]
Software (Microsoft Excel 365 ProPlus)

FOLLOW US
Website [ Ссылка ]
Facebook [ Ссылка ]
Twitter [ Ссылка ]

AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

свернуть