The AVERAGE is an Excel statistical function that calculates the average of its arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003.

**Note: **the AVERAGE will calculate the arithmetic average (adds up all the arguments and divides it with their count). If you need a median, use the MEDIAN function.

## Syntax

AVERAGE(number1, [number2], ...)

## Required Arguments

**number1**: Arguments can either be numbers or names, arrays, or references that contain numbers, which means 5, A2 and C4:C8 are all valid examples.

## Optional Arguments

**number2-255**: You can use up to 255 numbers in the calculation by following the syntax listed above.

**Note:** If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the ** AVERAGEA** function.

## AVERAGE Function Examples

### Using AVERAGE when some cells contain text

If some cells in your range contain text, logical values or are empty, Excel will just ignore them when calculating the average.

Keep in mind that the outcome can be very different with cells that contain 0 or are left empty.

### AVERAGE with cell ranges

## More Examples and Use Cases

We don’t have any use cases for this formula on our website at this moment but will link them below once we have. Stay tuned!