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

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