Calculate the average of a set of numbers and text.

`AVERAGEA(number1,[number2],...)`

- number1 - the first number, cell reference, or range to average
- number2, ... - [OPTIONAL] additional numbers, cell references, or ranges to average

`AVERAGEA(A1:A10)`

This function returns the average of the numbers in the range A1:A10. This includes logical values such as TRUE and FALSE, as well as numbers entered as text.

`AVERAGEA(TRUE,2)`

This example returns 1.5 when given two arguments, TRUE and 2.

`AVERAGEA("3",2)`

When given two arguments, "3" and 2, the function returns 2.5.

The AVERAGEA function is a powerful tool that can calculate the average of a variety of inputs, including numerical values, text representation of numbers, arrays, and references. It does not accept error values or text that cannot be converted into numbers.

- AVERAGEA takes up to 255 arguments, including numbers, cell references, ranges, constants, or arrays.
- AVERAGEA ignores empty cells and includes logical values and numbers entered as text in its calculation.

The AVERAGEA function calculates the average of its arguments. The arguments can be lists of numerical values, and AVERAGEA returns a number indicating the average value of the arguments.

AVERAGEA includes text representations of numbers and logical values directly entered into the arguments.

AVERAGEA evaluates empty text as zero.

AVERAGEA ignores non-numeric values in arrays or references.

AVERAGEA throws errors when error values cannot be turned into numbers.

The purpose of AVERAGEA is to measure the central tendency of a group of numbers.

- Average
- Median
- Mode

Drop CSV