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

## Leave a Reply