Search

# 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

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster