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
- number1, number2,.. 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:
| 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
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.