average
Arithmetic mean of numeric arguments (Excel-compatible).
Syntax
Section titled “Syntax”v = average(number1, number2, ...)Description
Section titled “Description”Returns the arithmetic mean of all numeric arguments. Text and logical values in cell ranges are skipped. Equivalent to Excel’s AVERAGE. For the script-mode array form with NaN handling, see mean.
Example
Section titled “Example”average(1, 2, 3, 4, 5) % 3See also
Section titled “See also”averagea— Arithmetic mean treating text as 0 and TRUE as 1.averageif— Mean of numbers in a range that meet a criterion.averageifs— Mean of numbers meeting multiple criteria.mean— Arithmetic mean.median— Median value.