AVERAGEA Function Explained
The AVERAGEA Function in Microsoft Excel calculates the average of all numbers in a range of cells, including numbers, text, logical values, and error values. It ignores empty cells, and can also be used to calculate the average of an array of values.
AVERAGEA Function Syntax
AVERAGEA(value1, [value2], ...)
- value1: The first value or range of values to average.
- value2: (optional) Additional values or ranges of values to average.