Formulas > =AVERAGE.WEIGHTED()
How to Use AVERAGE.WEIGHTED() in Google Sheets
Description
How To Actually Use AVERAGE.WEIGHTED() in Sheets
AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
Try AVERAGE.WEIGHTED yourself
In cells A1:A5, you have scores and in B1:B5, you have their corresponding weights. Use the AVERAGE.WEIGHTED formula in cell C1 to calculate the weighted average of the scores.
Hints (2)
-
Remember to match each score with its corresponding weight.
-
The first argument is the range of values, and the second is the range of weights.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the AVERAGE.WEIGHTED() formula:
Generate a AVERAGE.WEIGHTED() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses AVERAGE.WEIGHTED(). 2 free AI generations, no signup. Members get unlimited use.
Generate a AVERAGE.WEIGHTED() formula