Advanced Excel Average Formula

In this tutorial we will learn about Average Formula in Excel

Example:

Full Excel Course in Hindi

  • Get 2-Year Access with unlimited views of 220+ videos
  • Get Course Completion Certificate & Excel Mastery eBooks

There is a column which consists of 3 numbers 15, 10, and 5. Now we want to calculate all 3 numbers in order to get the Average. So to calculate the average we have 2 methods given below:

Method 1:

1. Go to Home Tab

2. Click on AutoSum Dropdown

3. Select the Average Formula

4. You will see the Average Formula

5. Press Enter and you will get your average answer as 10

Method 2:

1. Write =ave and select the average formula from the dropdown by pressing the Tab key

2. Select the entire range and close the bracket

3. Press Enter and you will get your average answer as 10

Now suppose if you have two data

1. First Data

In the first data you have a blank cell and want to calculate the average of the data. So to calculate the average just follow the steps given below:

1. Write =ave and select the average formula from the dropdown by pressing the Tab key

2. Select the entire range and close the bracket

3. Press Enter and you will get your average answer as 3

2. Second Data

In the second data you have 0 in your data and want to calculate the data’s average. So to calculate the average just follow the steps given below:

1. Write =ave and select the average formula from the dropdown by pressing the Tab key

2. Select the entire range and close the bracket

3. Press Enter

Note – Average Formula does not count the blank cells while calculating the Average but if you have 0 in your data then Average Formula counts 0 to calculate it.

4. Excel will calculate the average from the given data