AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel

AVERAGEA function: The function returns the average of the arguments including numeric, text, and logical values. Syntax: AVERAGEA (value1, [value2], ...)

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

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 1AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 1

Description: The function returns the average of the arguments including numeric, text, and logical values.

Syntax: AVERAGEA (value1, [value2], .)

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:

- Function arguments can be numbers, names, arrays, or references that contain numbers, text expressions, or logical values.

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

- The parameter value logic by True default is 1, the value False default is 0.

- 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 do not want to calculate the logical values ​​and numerical expressions written in the function, you should use the AVERAGE function .

For example:

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

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 2AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 2

- In the cell to calculate enter the formula: = AVERAGEA (C6: C10)

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 3AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 3

- Press Enter -> average of number values is:

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 4AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 4

- Replace the text value with the value 0 -> the result does not change -> the text type value is calculated in the function:

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 5AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 5

- Replace the value 0 with the logical value FALSE -> the result does not change ( FALSE value is defaulted to 0).

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 6AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 6

- Replace FALSE value with TRUE value -> change function results ( TRUE value is defaulted to 1).

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 7AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values ​​in Excel Picture 7

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

Good luck!

3.5 ★ | 2 Vote