AVERAGE.WEIGHTED function

The AVERAGE.WEIGHTED function finds the weighted average of a set of values, given the values and the corresponding weights.

Parts of an AVERAGE.WEIGHTED function

AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])

Part Description Notes
values The values to be averaged.
  • May refer to a range of cells, or may contain the values themselves.
weights The corresponding list of weights to apply.
  • May refer to a range of cells, or may contain the weights themselves.
  • Weights cannot be negative, though they can be zero.
  • At least one of the weights must be positive.
  • If using a range of cells, that range must have the same number of rows and columns as the range of values.
[additional_values] Additional values to average.
  • Additional values are optional.
[additional_weights] Additional weights to apply.
  • Additional weights are optional, but each additional_value must be followed by exactly one additional_weight.

 

Sample formulas

AVERAGE.WEIGHTED(10, 1, 20, 3)

AVERAGE.WEIGHTED(A1:A2, B1:B2)

AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2)

Examples

This example shows the weighted averages of different numbers and weights:

  A B C D
1 2 1 Formula Result
2 4 3 =AVERAGE.WEIGHTED(A1:A2, B1:B2) 3.5
3 8 6 =AVERAGE.WEIGHTED(2, 10, 4, 15) 3.2
4     =AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2) 6.2

 

This example of weighted average calculates someone's grade in a school course:

  A B C
1 Item Grade Percentage of final grade
2 Homework 95 25%
3 Participation 90 10%
4 Midterm exam 85 15%
5 Projects 88 20%
6 Final exam 82 30%
7   Formula Result
8 Final grade =AVERAGE.WEIGHTED(B2:B6, C2:C6) 87.7

Related functions

  • SUMPRODUCT: The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.
  • AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.
Was this article helpful?
How can we improve it?