Trending October 2023 # How To Find Mean In Excel # Suggested November 2023 # Top 13 Popular

You are reading the article How To Find Mean In Excel updated in October 2023 on the website Khongconthamnam.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested November 2023 How To Find Mean In Excel

What is Mean in Excel?

In Excel, the mean is also called the average. It’s a function that calculates the arithmetic mean, which means finding the average of a set of numbers. The average function adds all the values of a given range and divides the sum by the total count of cells.

In this article, we will learn How to Find Mean in Excel. For example, if you want to calculate the mean for 5, 10, 15, 20. The average function will add all the values (5 +10+15+20) and divide the sum by the total number of cells, i.e., 4. The result will be 12.5.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

The AVERAGE function is useful to calculate the average marks of students, the average salary of employees, and the average sales produced over time. This article explains how to find mean in Excel with five different methods and examples.

Where,

number1-It is a mandatory argument. It can be a number, range, or cell reference

[number2],..-It is an optional argument in the function.

How to Find Mean in Excel?

Select an empty cell to display the result

Enter the formula =AVERAGE(cell range). For instance: =AVERAGE(A5:A20)

Press “Enter”

The formula returns the arithmetic mean.

You can download this How to Find Mean Excel Template here – How to Find Mean Excel Template

Example #1: How to Calculate Arithmetic Mean in Excel?

Step 1: Select “Cell C2” and enter the formula:

AVERAGE(

A2:A11

)

Note: In the formula =AVERAGE(A2:A11), we have selected the range from A2 to A11. You can also type individual numbers in the formula.

Step 2: Press “Enter”.

Result: The formula will return 27.5.

Alternate Method:

Excel has an in-built function to calculate the average values in a continuous row or column. You can follow the following steps.

Step 3: Press “Enter”

Result: The formula will display 27.5 in Cell A12.

Example #2: How to Find the Mean of a Data Set?

Step 2: Select “Cell F2” and enter the formula:

AVERAGE(

B2:D2

)

Step 4: Drag the cell downwards.

Result: The formula will return average marks for respective students, as shown below.

ROUND(

AVERAGE(

B3:D3

),0

)

Example #3: Using AVERAGEIF for a Specific Condition

The AVERAGEIF function calculates the mean or average of a given data that meet certain criteria.

Step 1: Select “Cell C11” and enter the formula:

AVERAGE(

C2:C10

)

Step 3: Select “Cell C12” and enter the below formula:

AVERAGEIF(

A2:A10

“Sugar”

C2:C10

)

Step 4: Press “Enter”.

Result: The formula return the average of total sales for only sugar.

Note: You can see the difference between the AVERAGE and AVERAGEIF function results. The AVERAGE function has considered values from C2 to C10. The AVERAGEIF function has considered only Cell C4, C6, C8, and C9 values, representing sugar.

Example #4: Using AVERAGEIFS for Multiple Conditions

In the earlier example, we calculated the average of total sugar sales. Let’s say you want to calculate the average total sugar sales exceeding $40. You have to use the AVERAGEIFS function to accomplish this task.

Step 1: Select “Cell C11” and enter the formula:

Step 2: Press “Enter”.

Result: The formula returns the average value of total sugar sales exceeding $40.

Example #5: Using AVERAGEA

Points to remember while using the AVERAGEA function:

Text strings are evaluated as

Boolean or Logical value like TRUE is considered 1 and FALSE as 0.

Empty text (“”) in the cell is also evaluated as 0.

Step 1: Select “Cell C12” and enter the formula:

AVERAGEA(

C2:C10

)

The formula will return 25.47777778 in Cell C12, as shown below.

Result: The formula will return the average of total sales

Step 3: Select “Cell C13” and enter the formula:

AVERAGE(

C2:C10

)

Here, the AVERAGEA function has taken the Cell C5 and Cell C10 values (Text-Non Sold) as 0 and divided the sum by 9, i.e., the total count of cells in the data.

Here, the AVERAGE function ignores Cell C5 and Cell C10 values and divides the sum by 7.

Things to Remember on How to Find Mean in Excel

A user can give 255 input arguments in the AVERAGE function, which includes numbers, text strings, arrays, cell references, and logical values (TRUE or FALSE).

If any cells do not meet the above criteria, Excel will display a #DIV01 error.

The AVERAGEA function will evaluate 1 for TRUE and 0 for FALSE values.

To calculate the mean with specific conditions, use AVERAGEIF or AVERAGEIFS.