AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
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!
You should read it
- MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
- MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
- AVERAGE function - The function returns the average of the arguments in Excel
- AVERAGEIF function - The function returns the average of the arguments with the conditions specified in Excel
- AVERAGEIFS function - The function returns the average of the arguments that meet multiple conditions in Excel
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
- STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel
- VARA - Function that calculates variance based on a sample, including logical values and text in Excel
- STDEV.P function - The function returns the standard deviation based on the whole in Excel
- STDEVPA function - The function of estimating standard deviations based on an entire population including both text and logical values in Excel
- STDEV.S function - The function returns the standard deviation based on a sample in Excel
- VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel