AVERAGE Function in Excel – Calculate Arithmetic Mean

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

AVERAGE Function in Excel 1

  • Arithmetic mean is calculated either by passing values or reference to the average function as shown above so the result will be
Result

AVERAGE Function in Excel 2

Note:
  • Logical values, within arrays or reference arguments are ignored
  • Text, within arrays or reference arguments are ignored
  • Empty cells are ignored

previous AVERAGE Function in Excel                                                                                                                 next AVERAGE Function in Excel