Returns a weighted average (the mean, where each value is weighted by its relative importance).
Sample Usage
AVGW(Cost1:Cost5, Quantity1:Quantity5)
Syntax
AVGW(
-
range
-
range_weight
-
range—The group of numbers to average.
-
range_weight—A corresponding group of numbers that represent the number of times you want each value counted.