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 |
|---|---|---|
| AVGW([10, 20, 30], [1, 2, 3]) | Calculates the weighted average of 10, 20, and 30 with weights 1, 2, and 3 respectively. | 23.33 |
| AVGW([100, 200, 300], [3, 2, 1]) | Finds the weighted average of 100, 200, and 300, where the numbers are weighted inversely to their size. | 166.67 |
| AVGW([4.5, 3.2, 7.8], [10, 5, 2]) | Calculates the weighted average of decimal numbers with corresponding weights. | 4.91 |
| AVGW([50, 75, 25], [0.5, 0.3, 0.2]) | Computes the weighted average using fractional weights for the numbers. | 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.