AVG Function

Returns the average (mean) of the provided numbers.
Sample Usage
AVG(Cost1:Cost5)
Syntax
AVG(
  • number1
  • [
    • number2
      • ​
    • ...
    ]
)
  • number1
    —
    The number, cell reference, or range for which you want the average.
    • number2
      • ​
    • ...
    —[optional]
    Additional numbers, cell references, or ranges for which you want the average.
Related Functions
AVGW
MIN
MAX
Was this article helpful?
YesNo