AVERAGE.WEIGHTED
Average of values weighted by a second range.
- Excel: No equivalent
- Google Sheets: Not checked yet
- Returns: Number
Examples
=AVERAGE.WEIGHTED(A1:A3, B1:B3) | A | B | |
|---|---|---|
| 1 | 10 | 2 |
| 2 | 20 | 4 |
| 3 | 30 | 6 |
Result 23.333333333333332
Syntax
AVERAGE.WEIGHTED(values, weights)values- range required
weights- range required
Errors
#VALUE!=AVERAGE.WEIGHTED(A1:A3, 2)