# How To Calculate Average In Excel

5.8 min read|Last Updated: February 8th, 2024|Categories: excel|
table of content

The average is a typical exhibition of a data set, which is provided in the Excel spreadsheet in 4 functions for various situations. In this tutorial, we’re going to learn how to use these functions in Excel.

In this blog (and many other articles) average and mean are used interchangeably.

In mathematics, the average is the same as “arithmetic mean” or simply mean. To be more precise, it has to be stated that “mean” has several definitions, one of which i.e. arithmetic mean is equal to average. Geometric and harmonic mean are examples of different mean concepts and definitions.

According to picture 1, the average functions include:

## AVERAGE

Which is used to calculate the arithmetic mean for a group of numbers.

The Set of data, which is one or more numeric values, is the number in the syntax of the function.

There are more ways to calculate the average:

1. Use the AVERAGE function (according to video 1):
1. Enter the AVERAGE function in an empty cell.
2. Select your data as a range.
3. Press Enter.
1. Use the SUM function and divide by the COUNT function according to video 2:
1. Enter the SUM function in an empty cell.
2. Select your data as a range.
3. Divide by the COUNT function.
4. Select your data as range, again.
5. Press Enter.
1.  Add a quick calculation to your worksheet, automatically, such as the AVERAGE.
1. Select an empty cell.
2. Click on the FORMULAS tab.
3. Click on the AUTOSUM.
4. Select the AVERAGE from the list.