AVGW Function

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.
Related Functions
AVG
MIN
MAX