## 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**

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

### Remarks

,*number1*,.. can be numbers, ranges, names, or cell references that contain numeric values.*number2*- You can specify the additional arguments up to 255.

**Excel AVERAGE Function Examples**

Demo data:

A | B | C | D | E | F | |

1 | Date | Code | Item Name | Quantity | Price ($) | Amount ($) |

2 | 10/5/2019 | Item022 | Desktop PC 22 | 3 | 225 | 675 |

3 | 10/5/2019 | Item011 | Desktop PC 11 | 2 | 750 | 1500 |

4 | 10/5/2019 | Item033 | Desktop PC 33 | 1 | 235 | 235 |

5 | 10/6/2019 | Item022 | Desktop PC 22 | 3 | 785 | 2355 |

6 | 10/6/2019 | Item011 | Desktop PC 11 | 3 | 1050 | 3150 |

7 | 10/8/2019 | Item033 | Desktop PC 33 | 1 | 275 | 275 |

8 | 10/9/2019 | Item022 | Desktop PC 22 | 4 | 290 | 1160 |

**Finding an average of a group of numbers **

**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.