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.

The average is provided in the Excel in 4 functions.
Picture 1- The average functions in Excel

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.

The Set of data is the number in the syntax of the function.
Picture 2- The syntax of the AVERAGE 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.
Video 1- The AVERAGE function
  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.
Video 2- Use the SUM and COUNT function to calculate the average
  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.
  5. Highlight your target data.
  6. Press Enter.