AVERAGE function - The function returns the average of the arguments in Excel

The following article introduces you to the AVERAGE function - one of the functions in the statistical function group is very popular in Excel.

AVERAGE function - The function returns the average of the arguments in Excel Picture 1

Description: The function returns the average of the arguments.

Syntax: AVERAGE (number1, [number2], .)

Inside:

- number1, number2 . are the values ​​you want to calculate the average absolute deviation, where number1 is the required parameter, the remaining number values are optional. The function contains up to 255 number values .

Attention:

- AVEDEV function is affected by the measurement unit of input data.

- The values ​​of the arguments must be either numbers or names or references that contain numeric values.

- When typing logical values ​​directly and displaying text numbers in functions, these values ​​will be calculated.

- Parameter values ​​or arrays that are logical values, text or blank cells are ignored.

- In case you want to calculate the logical values ​​and numerical expressions written in the function, you should use AVERAGEA function .

- If you want to calculate the average of the values ​​that meet certain conditions, you should use the AVERAGEIF function or the AVERAGRIFS function .

For example:

Calculate the average of the values ​​in the following data table:

AVERAGE function - The function returns the average of the arguments in Excel Picture 2

- Calculate the average of the number values in the data table. In a cell to calculate enter the formula: = AVERAGE (C6: C10)

AVERAGE function - The function returns the average of the arguments in Excel Picture 3

- Press Enter -> average of number values is:

AVERAGE function - The function returns the average of the arguments in Excel Picture 4

- Calculate the average of the values ​​of number and 25 -> enter the formula: = AVERAGE (C6: C10,25)

AVERAGE function - The function returns the average of the arguments in Excel Picture 5

- Press Enter -> the average of the values ​​of number and 25 is:

AVERAGE function - The function returns the average of the arguments in Excel Picture 6

- Where number values are blank cells or text -> they are ignored.

AVERAGE function - The function returns the average of the arguments in Excel Picture 7

Above are instructions and specific examples when using the AVERAGE function in Excel.

Good luck!