**How to Find Mean in Excel (Table of Content)**

## Introduction to Mean in Excel

Average function is used to calculate the Arithmetic Mean of the given input. It is used to do sum of all argument and divide it by count of argument where the half set of the number will be smaller than the mean and remaining set will be greater than mean. It will return the arithmetic mean of the number based on provided input. It is an in-built Statistical function. A user can give 255 input argument in the function.

As an example, suppose there is 4 number 5,10,15,20 if a user wants to calculate the mean of the numbers then it will return 12.5 as the result of **=**AVERAGE (5, 10, 15, 20).

**Formula of Mean:** It is used to return the mean of the provided number where a half set of the number will be smaller than the number and the remaining set will be greater than mean.

**Argument of the Function:**

**number1**: It is a mandatory argument in which functions will take to calculate the mean.

**[number2]**: It is an optional argument in the function.

**Examples on How to Find Mean in Excel**

Here are some examples of how to find mean in excel with the steps and the calculation

### Example #1 – How to Calculate the Basic Mean in Excel

Let’s assume there is a user who wants to perform the calculation for all numbers in Excel. Let’s see how we can do this with the average function.

4.9 (2,205 ratings)

View Course

**Step 1:** Open MS Excel from the start menu >> Go to Sheet1 where the user has kept the data.

**Step 2: **Now create headers for Mean where we will calculate the mean of the numbers.

**Step 3: **Now calculate the mean of the given number by average function>> use the equal sign to calculate >> Write in cell C2 and use average>> “=AVERAGE (“

**Step 3: **Now it will ask for number1 which is given in column A >> there are 2 methods to provide input either a user can give one by one or just give the range of data >> select data set from A2 to A11 >> write in cell C2 and use average>> “=AVERAGE (A2: A11) “

**Step 4: **Now press the enter key >> Mean will be calculated.

**Summary of Example 1: **As the user wants to perform the mean calculation for all number in the MS Excel. Easley everything calculated in the above excel example and the Mean is 27.5 for sales.

### Example #2 – How to Calculate Mean if Text Value Exists in the Data Set

Let’s calculate Mean if there is some text value exists in data set in Excel. Let’s assume there is a user who wants to perform the calculation for some sales data set in Excel. But there is some text value also there. So, he wants to use count for all either its text or number. Let’s see how we can do this with the AVERAGE function. Because in the normal AVERAGE function it will exclude the text value count.

**Step 1:** Open MS Excel from the start menu >> Go to Sheet2 where user has kept the data.

**Step 2: **Now create headers for Mean where we will calculate the mean of the numbers.

**Step 3: **Now calculate the mean of the given number by average function>> use the equal sign to calculate >> Write in cell D2 and use AVERAGEA>> “=AVERAGEA (“

**Step 4: **Now it will ask for number1 which is given in column B >> there is two open to provide input either a user can give one by one or just give the range of data >> select data set from B2 to B11 >> write in D2 Cell and use average>> “=AVERAGEA (D2: D11) “

**Step 5: **Now click on the enter button >> Mean will be calculated.

**Step 6: **Just to compare the AVERAGEA and AVERAGE**,** in normal average, it will exclude the count for text value so mean will high than the AVERAGE MEAN.

**Summary of Example 2: **As the user wants to perform the mean calculation for all number in the MS Excel. Easley everything calculated in the above excel example and the Mean is $146377.80 for sales.** **

### Example #3 – How to Calculate Mean for Different Set of Data

Let’s assume there is a user who wants to perform the calculation for some students mark data set in the MS Excel. There are ten student marks for Math, English, and Science out of 100. Let’s see How to Find Mean in Excel with the AVERAGE function.

**Step 1:** Open the MS Excel from the start menu >> Go to Sheet3 where user kept the data.

**Step 2: **Now create headers for Mean where we will calculate the mean of the numbers.

**Step 3: **Now calculate the mean of the given number by average function>> use the equal sign to calculate >> Write in F2 Cell and use AVERAGE >> “=AVERAGE (“

**Step 3: **Now it will ask for number1 which is given in B, C, and D column >> there is two open to provide input either a user can give one by one or just give the range of data >> Select data set from B2 to D2 >> Write in F2 Cell and use average >> “=AVERAGE (B2: D2) “

**Step 4: **Now click on the enter button >> Mean will be calculated.

**Step 5: **Now click on F2 cell and drag and apply to another cell in F column.

**Summary of Example 3: **As the user wants to perform the mean calculation for all number in the MS Excel. Easley everything calculated in the above excel example and the Mean is available in F column.

**Things to Remember About How to Find Mean in Excel**

- Microsoft Excel’s AVERAGE function used to calculate the Arithmetic Mean of the given input. A user can give 255 input argument in the function.
- Half set of a number will be smaller than the mean and remaining set will be greater than mean.
- If a user calculating the normal average, it will exclude the count for text value so AVERAGE Mean will bigger than the AVERAGE MEAN.
- Arguments can be number, name, range or cell references that should contain a number.
- If a user wants to calculate mean with some condition, then use AVERAGEIF or AVERAGEIFS.

### Recommended Articles

This is a guide to How to Find Mean in Excel. Here we discuss How to Find Mean along with examples and downloadable excel template. You may also look at the following articles to learn more –