AVERAGEA

Excel Functions

Get the average of a group of numbers and text

Syntax

EXCEL

=AVERAGEA(value1, [value2], ...)

Arguments

Parameter	Description
`value1`	A value or reference to a value that can be evaluated as a number.
`value2`	[optional] A value or reference to a value that can be evaluated as a number.

Return Value

A number representing the average.

Details

The AVERAGEA function returns the average of a set of supplied values. AVERAGEA will include the logical values TRUE and FALSE, and numbers represented as text in the calculation. The AVERAGE function ignores these values during calculation AVERAGEA takes multiple arguments in the form of value1, value2, value3, etc. up to 255 total. Arguments can include numbers, cell references, ranges, arrays, and constants. Empty cells are ignored, but zero (0) values are included. To average values in the range A1:A10, including logical the logical values TRUE (1) and FALSE (0) and numbers entered as text, use AVERAGEA like this: One confusing aspect of the AVERAGE function compared to the AVERAGEA function is that both functions will evaluate logicals and numbers entered as text when they are hardcod

Examples

To average values in the range A1:A10, including logical the logical values TRUE (1) and FALSE (0) and numbers entered as text, use AVERAGEA like this

EXCEL

=AVERAGEA(A1:A10) // average numbers, logicals, numbers as text

Examples

One confusing aspect of the AVERAGE function compared to the AVERAGEA function is that both functions will evaluate logicals and numbers entered as te

EXCEL

=AVERAGE(TRUE,2) // returns 1.5
=AVERAGEA(TRUE,2) // returns 1.5
=AVERAGE("3",2) // returns 2.5
=AVERAGEA("3",2) // returns 2.5

AVERAGEA

Syntax

Arguments

Return Value

Details

Examples

See Also