Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT) - Excel Tips and Tricks
135 Views • Sep 30, 2025
Description
Here are the formulas outline in the video.
Calc Weighted Average (slow method)
=C5*$C$2+D5*$D$2+E5*$E$2+F5*$F$2
Calc Weighted Average (fast method)
=SUMPRODUCT(C5:F5,$C$2:$F$2)
How do you calculate a weighted average?,How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT),How do I calculate weighted average in Excel for two columns?,What is the formula for the SUMPRODUCT in Excel?,
More from User
Highlight duplicate cell in another sheet in Excel - Excel Tips and Tricks
ExcelTips247
How do you align charts to cells in Excel? - Excel Tips and Tricks
ExcelTips247
Hide cell values in Excel - Excel Tips and Tricks
ExcelTips247
How do I add a Choosecols function in Excel? - Excel Tips and Tricks
ExcelTips247
Get maximum of comma-separated values in a cell In Excel - Excel Tips and Tricks
ExcelTips247
Consolidate Data from Multiple Table Using SUMIF() in Excel... Another method - Excel Tips and Tricks
ExcelTips247
Related Videos
"Calculate AVERAGE in Excel – Tips & Tricks You Need to Know!" | "Master AVERAGE Calculation in Excel – Full Tutorial"
Mr. EXCEL HACKS
Calculate age using YEARFRAC in Excel - Excel Tips and Tricks
ExcelTips247
Calculate percentage in Excel using Quick Analysis - Excel Tips and Tricks
ExcelTips247
Rating Chart Using REPT() Function in Excel - Excel Tips and Tricks
ExcelTips247
Sum comma separated values in Excel Without Using TEXTSPLIT() Function - Excel Tips and Tricks
ExcelTips247
Calculate Expiry Date in Excel – Tips & Tricks You Need to Know | Calculate Expiry Date in Excel Like a Pro | Excel Tips and Tricks
Mr. EXCEL HACKS