Returns a weighted average (the mean, where each value is weighted by its relative importance)
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
Sample usage
AVGW(Cost1:Cost5, Quantity1:Quantity5)
Examples
Formula | Description | Result |
---|---|---|
Formula AVGW([10, 20, 30], [1, 2, 3]) | Description Calculates the weighted average of 10, 20, and 30 with weights 1, 2, and 3 respectively. | Result 23.33 |
Formula AVGW([100, 200, 300], [3, 2, 1]) | Description Finds the weighted average of 100, 200, and 300, where the numbers are weighted inversely to their size. | Result 166.67 |
Formula AVGW([4.5, 3.2, 7.8], [10, 5, 2]) | Description Calculates the weighted average of decimal numbers with corresponding weights. | Result 4.91 |
Formula AVGW([50, 75, 25], [0.5, 0.3, 0.2]) | Description Computes the weighted average using fractional weights for the numbers. | Result 52.75 |
Still need help?
Use the Formula Handbook template to find more support resources and view 100+ formulas. It includes a glossary of every function that you can practice working with in real-time and examples of commonly used and advanced formulas.
You can find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.