# How to Use Excel AVERAGE Function (Examples + Video)

## Excel AVERAGE Function (Example + Video) ### When to use Excel AVERAGE Function

AVERAGE function can be used when you want to get the average (arithmetic mean) of the specified arguments.

### What it Returns

It returns a number that represents the average (arithmetic mean) of the arguments.

### Syntax

=AVERAGE(number1, [number2], …)

### Input Arguments

• number1 – the first number, cell reference, or range for which you want the average.
• [number2] – (Optional) the second number, cell reference or range for which you want the average. There can be a maximum of up to 255 additional arguments.

• Arguments can be numbers, named ranges, or cell references that contain numbers.
• Cells references with text, logical values, or empty cells are ignored, but cells with 0 are counted for averaging
• Logical values and text representations of numbers that you type directly into the list of arguments are counted.
• Arguments that are error values or text that cannot be translated into numbers cause errors.

## Excel AVERAGE Function – Video Tutorial

You May Like the Following Excel Tutorials:

Related Excel Functions: FREE EXCEL BOOK