To calculate a weighted average in Excel:
-
Enter your data in two columns: one for values and one for weights.
-
Use the formula =SUMPRODUCT(values_range, weights_range)/SUM(weights_range) .
Example:
-
Values in A2:A4: 20, 25, 35
-
Weights in B2:B4: 500, 750, 200
-
Formula: =SUMPRODUCT(A2:A4, B2:B4)/SUM(B2:B4)
-
Result: 24.66
Tip:Â For more details, see Calculate the average of a group of numbers.
