# Excel AVERAGE Function

Summary

The Excel AVERAGE function returns the average of values supplied as multiple arguments. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

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.- The AVERAGE function will automatically ignore empty cells.

Good links

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.