The AVERAGE function in Excel returns the arithmetic mean of a list of supplied numbers.
Syntax of AVERAGE Function in Excel
AVERAGE (number1, [number2], …)
Where the number arguments are a set of one or more numeric values, or arrays of numeric values, for which you want to calculate the average.
Example of AVERAGE Function in Excel
- Arithmetic mean is calculated either by passing values or reference to the average function as shown above so the result will be
Result
Note:
- Logical values, within arrays or reference arguments are ignored
- Text, within arrays or reference arguments are ignored
- Empty cells are ignored