Excel AVERAGE Function
This tutorial explains how to use the Excel AVERAGE function.
Description
The Excel AVERAGE function returns the average of the arguments that you specify.
There are other AVERAGES functions that you can use to calculate the average of a group of numbers (AVERAGEA, AVERAGEIF, and AVERAGEIFS).
- Use the Excel AVERAGEIF function if you want to calculate the average of only the values that meet single criteria.
- Use the Excel AVERAGEIFS function if you want to calculate the average of only the values that meet the multiple criteria.
- Use the Excel AVERAGEA function if you want to include logical values and text representations of numbers in a reference as part of the calculation.
Syntax
=AVERAGE (number1, [number2], …)
Arguments
- number1: The first number, cell reference, or range that you want to calculate the average.
- number2: [Optional]. The additional numbers, cell references or ranges that you want the average.
number1, number2,.. can numbers, ranges, names, or cell references that contain numeric values.
You can specify the additional arguments up to 255.
Example
Here is our sample data.
A | B | C | D | E | F | G | |
1 | Date | Code | Item Name | Quantity | Price ($) | Amount ($) | Employee |
2 | 10/5/2016 | Item02 | HP Desktop PC | 2 | 225 | 450 | John |
3 | 10/5/2016 | Item01 | Dell Desktop PC | 2 | 750 | 1500 | James |
4 | 10/5/2016 | Item03 | Sony Desktop PC | 1 | 235 | 235 | John |
5 | 10/6/2016 | Item02 | HP Desktop PC | 3 | 785 | 2355 | Roland |
6 | 10/6/2016 | Item01 | Dell Desktop PC | 3 | 1050 | 3150 | Stephen |
7 | 10/8/2016 | Item03 | Sony Desktop PC | 1 | 275 | 275 | James |
8 | 10/9/2016 | Item02 | HP Desktop PC | 4 | 290 | 1160 | Roland |
Example 1:
=AVERAGE(F2:F8)
In Example 1, we want to get the average of the sales amount in column F. There is an only argument (F2:F8) in the AVERAGE formula above. AVERAGE returns the average of the numbers in the range F2:F8. The result is 1128.33333333333.
Example 2:
=AVERAGE(F2:F7,F8)
In Example 2, we want to get the average of the sales amount in column F as Example 1. As you can see, there two arguments (F2:F7, F8) in the formula. The AVERAGE returns the average of the numbers in the range F2:F7 and F8. The result is the same as Example 1.
Example 3:
Let’s another example below.
=AVERAGE(F2:F7,F8,150,200,400)
In Example 3, there five arguments in the formula. The AVERAGE calculates the average of the numbers in the range F2:F7, F8, 150, 200, and 400.
In this tutorial, you learned how to use the Excel AVERAGE function. We use the Excel AVERAGE function to calculate the average of a group of numbers.
Here is a full list of Microsoft Excel functions.
Leave a Reply