# 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.