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.