Average function (calculate the average) in Excel

The Average function in Excel helps you calculate the average value for a range of numbers, an array, or a reference containing numbers quickly and accurately. You will not have to spend time performing each calculation to calculate the average, but simply use the Average function directly.

Average function (calculate the average) in Excel Picture 1

The following article describes the syntax and usage of the Average function in Excel.

Description

The Average function returns the average of the input arguments (also understood as the result of dividing the total value of the arguments by the total number of arguments). The input values are numbers or ranges, referencing cells that contain numbers.

Also you can use the following functions:

AVERAGEA function: returns the average of all values in a column, processing text values and not numbers.

AVERAGEIF function or AVERAGEIFS function: if you only want to calculate the average of those values that meet certain conditions and criteria.

Syntax

= AVERAGE (number1, [number2], .)

Inside:

- number1: The first argument can be a number, a cell reference or a range containing the number you want to average, required.

- number2: is the number, cell reference or range containing additional numbers that you want to calculate a maximum of 255 numbers on average, optional.

Note

- If a cell or range reference argument contains a logical value, text, or an empty cell, those values will be ignored, except that the value 0 will be calculated.

- The logical values, denoting the number of text types that you type directly into the list of arguments in the function will be counted.

- If an argument is text or a value cannot be converted into a number, an error will occur.

For example

For the data sheet:

Average function (calculate the average) in Excel Picture 2

1. Calculate the average of the numbers from B5-> B8.

Apply the function: = AVERAGE (B5: B8) we get the result:

Average function (calculate the average) in Excel Picture 3

2. Calculate the average of the numbers from D5 -> D8 and number 10.

Applying the function: = AVERAGE (D5: D8,10) we get the following result:

Average function (calculate the average) in Excel Picture 4

3. Calculate the average of the numbers from B5 -> E8.

Apply the function: = AVERAGE (B5: E8) and the result is as follows:

Average function (calculate the average) in Excel Picture 5

The article showed how to use the Average function to calculate the average value, this is a fairly common function and many applications in calculating in Excel that you should know. Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

Find, FindB functions in Excel - The function finds a text string in another document in Excel
the find and findb functions help you find a text string in another text and return the value as the location of the text string to be found in the search text. depending on the different default languages that you apply the find or findb function properly.
The INT (Function rounds a number down to the nearest integer of a number) in Excel
the int function helps you get the integers of a number, often used to process the result of a division in excel.
The Match function (the function searches for a specified value in an array or cell range) in Excel
the match function helps you search for a specified value in an array, a range of cells, and then returns the position of the value in that array or range.
The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel
mode returns the most frequently occurring, repeated value in a given data array. mode is not as common as other functions, but sometimes you still have to use mode to get statistics when needed.
Hide value 0 in Excel
in the process of working with excel spreadsheets, for some reason, sometimes you want to hide all zero values. to do this, you only need to perform very simple steps, but if you do not pay attention you may not know how to do it.
Use Sparklines in Excel
spark lines in excel is a small chart that you can put inside cells to view data and charts on the same table. you may know a lot about how to use charts in excel but maybe you do not know sparklines.