Returns the average value of a series of numbers and/or cells.

**Sample Usage**

AVERAGE(20,30)

AVERAGE(A2:A6)

AVERAGE(A1:B2,5)

**Syntax**

AVERAGE(value1, [value2, ...])

- value1 - The first number or range to consider while calculating the average value.
- value2, .. - [OPTIONAL] Additional numbers or ranges to consider.

**Examples**

AVERAGE(20,30) returns a value of 25.

AVERAGE(A2:A6) returns the average of the numbers in cells A2 through A6.

AVERAGE(A1:B2,5) returns the average of the numbers contained in cells A1 through B2 and the number 5.

**Notes**

- Any text encountered in the arguments will be ignored. To include logical values and text representations of numbers as part of the calculation, use the AVERAGEA function.
- Cells with the value of zero are included in the calculation.