## Purpose

Get the average of a group of numbers

## Return value

A number representing the average.

## Syntax

=AVERAGE (number1, [number2], …)

## Arguments

**number1**– A number or cell reference that refers to numeric values.**number2**– [optional] A number or cell reference that refers to numeric values.

## Usage notes

The AVERAGE function returns the average (arithmetic mean) of a group of supplied numbers. To calculate the average, Excel adds the numbers together and divides by the total number of numbers. For example, AVERAGE (2,4,6) returns 4.

**Numbers** can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. Up to 255 **numbers** can be supplied.

*Note: the AVERAGE function will automatically ignore empty cells.*