# Excel AVERAGE Function and Formula with Examples

## How to Use the AVERAGE Function and Formula in Excel

In this tutorial, you'll learn how to use the AVERAGE function and formula in Excel.

AVERAGE() calculates the average of a group of numbers.

### AVERAGE Syntax

The syntax of the AVERAGE() function is as follows:

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

### Arguments

• number1: The first number, ranges, or cell reference
• number2: Optional. Numbers, cell references, or ranges.

### Remarks

• number1number2,.. can be numbers, ranges, names, or cell references that contain numeric values.
• You can specify the additional arguments up to 255.

### Excel AVERAGE Function Examples

Demo data:

#### Finding an average of a group of numbers

The following example returns the average of a group of 5 numbers:

=AVERAGE(200, 100, 400, 300, 600)

AVERAGE() finds an average of numbers 200, 100, 400, 300, and 600 and returns 320.

#### Finding an average of numbers in a range of cells

The following example returns the average of numbers in a range of cells:

=AVERAGE(F2:F8)

The above formula returns 1335.714.

#### Finding an average of numbers in a range of cells and the additional cell

Here is an example:

=AVERAGE(F2:F7,F8)

The above formula returns 1335.714.

#### Finding an average of numbers in a range of cells, a cell, and the other three numbers

Here is an example:

=AVERAGE(F2:F7,F8,150,200,400)

The above formula returns 1010.

In this tutorial, you've learned how to use the Excel AVERAGE function.

AVERAGE is a function to find an average of a group of numbers.