How to calculate mean in Excel? [Easy Step-by-Step Method]

How To Square A Number In Excel 3

The mean is the average or the most common value in a set of numbers. In this article, we will learn how to calculate the mean in Excel.

Steps to Calculate Mean in Excel

Let us consider the following dataset of a group of students with their marks:

calculate mean in Excel

We are interested in finding the mean of the marks scored by the students. To calculate the mean in Excel, we use an in-built AVERAGE function. The syntax of the AVERAGE function is =AVERAGE(start cell reference:end cell reference).

  • Select the cell where you want to display the mean.
  • Type the formula =AVERAGE( and select the data range containing the values for which mean value is sought.
  • Finish the formula with ) and press the Enter key.

In this example, we enter the formula =AVERAGE(B2:B11) in cell B13, to get the mean of the marks obtained by students:

mean of marks

Note: The AVERAGE function ignores empty cells and cells that do not include any numbers.


In this article, we learned how to calculate the mean in Excel using the AVERAGE formula.