AVERAGEA function
Returns the average of its arguments, including numbers, text, and logical values
Returns the average of its arguments, including numbers, text, and logical values.
Syntax
AVERAGEA(value1, [value2])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| value1 | Yes | The first number, cell reference, or range for which you want the average.A1:A20 |
| value2 | No · repeats | Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.B1:B20 |
Try AVERAGEA
Mean of the numeric source
=AVERAGEA(A2:A6)All five supplied values are numbers, so this sample matches AVERAGE. Text and logical-value rules need separate examples.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
AVERAGEA · top-level call
=AVERAGEA(A2:A6)1 / 1 · value1
The first number, cell reference, or range for which you want the average.
AVERAGEA reference ↗Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.