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

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

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 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 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 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 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 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 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 7

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

Good luck!

text

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel
varpa function: function that calculates variance based on the entire set, including logical values and text. syntax: varpa (value1, [value2], ...)
STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
var.s function: function that calculates variance based on a sample, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.s (number1, [number2], ...)
VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
var.p function: function that calculates variance based on the entire set, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.p (number1, [number2], ...)
PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
percentrank.inc function: the function returns the rank of a value in a dataset as a percentage including values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.inc (array, x, [significance])
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
rank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
How to use the MAXA function in Excel, detailed examples
the maxa function in excel helps find the largest value in a data set, including numbers, logical values, and text containing numbers. this is different from the max function, which only counts numbers. let's learn the syntax and usage of the maxa function with practical examples.
QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
quartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
MINA function in Excel, how to use and examples
the mina function in excel helps determine the smallest value in a range of numbers, including logical values and text numbers. with simple syntax, mina supports optimizing the calculation process in spreadsheets.
TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
trimmean function: the function returns the average of the inside of the data set. the function calculates by removing which percentage of the value is in the first or last boundary of the data set. syntax: trimmean (array, percent)