How to get average in Excel?

The average is the sum of several values ​​and division by the total number of values added. It is also known as the mean or arithmetic mean.

In this article we will explain how to take the average in Excel quickly and easily. Likewise, you will see different variations of the formula to get the most out of it.

AVERAGE

The AVERAGE function is responsible for add the values ​​and divide them by the total number of figures added. For example, the average of 15, 5, 10, 12 and 8 would be 10, since all the values ​​are added and divided by 5 because it is the number of numbers added.

Syntax

The arguments of the AVERAGE function are as follows:

• Number 1: is the first piece of data that can be a number, range, or cell reference.
• Number2: is another piece of data that must be a number, range, or cell reference.

Example

To use the AVERAGE function in Excel, you simply enter the values ​​vertically or horizontally in the spreadsheet. Then, in an empty cell, enter “=AVERAGE(”.

Hold click on the first value and drag it to the last one. You should create a range like this “=AVERAGE(C3:C14)”. Close parentheses and press “Enter”.

AVERAGE.YES

The AVERAGEIF function in Excel is used to find the average of a set of values ​​that meet a condition.

Syntax

These are arguments that make up the AVERAGEIF function in Excel:

• Range: is the range of cells where the criterion or condition to be met will be searched.
• Criterion: is the condition that will be applied. It can be a numerical or textual expression that will sort the cells to be added.
• – These are the cells that will be used to calculate the average. If omitted, the cells in the range will be used.

Example

To use the AVERAGEIF function in Excel, just follow these steps:

1. Enter all the data into the spreadsheet. In an available cell type “=AVERAGE.IF(”. In this case, the average sales in the makeup department will be calculated.
2. Now, in “range”, select the range of cells where the criterion will be searched. In this case it is “B3:B14”. Add a semicolon to continue.
3. In “criterion”, write the condition to apply. In this example, you only want to average the cells that say “Make-up”, therefore, this criterion will be written in quotes because it is a text string. Insert semicolon.
4. In “”, select the range of cells to average. In this case it is “C3:C14”.
5. Close parentheses and press “Enter” to see the result.

AVERAGE IF JOINT

The AVERAGEIF SET function is used to calculate the average of cells that meet several conditions. That is, if you want to apply several conditions when averaging, you must use this formula.

Syntax

The elements that make up the AVERAGEIF SET function are:

• average_range: are the group of cells where the average will be calculated.
• criteria_range1: is the range of cells in which the specified condition will be searched.
• Criterion1– is the condition or criterion that will be applied to determine which cells will be used to calculate the average.
• criteria_range2: is the range of cells in which the second condition or criterion will be searched.
• Criterion2: is the second condition or criterion that will be applied in Criterion_Range2.

Example

If you want to use the AVERAGEIF SET function in Excel, you can use the previous example and follow the following steps:

1. Enter the data into the Excel sheet. In an empty cell write “=AVERAGEIF SET(”. In this example, we want to know the average sales of Claudia Rojas in the Facial Care department. There are two conditions that can be applied for this formula.
2. In “average_range”, selects the range of cells from which the average will be obtained. In this case it will be the “Sales” column, the range “C3:C14”. Add semicolons to separate arguments.
3. In “criteria_range1”, choose the range where the first condition will be searched. In this example it will be “A3:A14”.
4. In “criterion1”, write the first condition. Here it will be written in quotes “Claudia Rojas”.
5. Now in “criteria_range2”, selects the range where the second condition will be searched. Here it will be “B3:B14”.
6. In “criterion2”, indicates the second condition to apply. In this example, “Facial care” will be written in quotes.
7. Close parentheses and press “Enter” to get a result.

Note– You can add more than two conditions with this function. You just have to be careful to correctly specify both the ranges and the criteria to be evaluated.

In conclusion, the process to obtain an average in Excel is simple thanks to the AVERAGE, AVERAGE.IF and AVERAGE.IF.JOINT functions. You just have to choose the one you need.