The following article introduces you to the AVERAGEA function - one of the functions in the statistical function group is very popular in Excel.
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:
- In the cell to calculate enter the formula: = AVERAGEA (C6: C10)
- Press Enter -> average of number values is:
- Replace the text value with the value 0 -> the result does not change -> the text type value is calculated in the function:
- Replace the value 0 with the logical value FALSE -> the result does not change ( FALSE value is defaulted to 0).
- Replace FALSE value with TRUE value -> change function results ( TRUE value is defaulted to 1).
Above are instructions and specific examples when using the AVERAGEA function in Excel.
Good luck!