Average

Average is a mathematical function that returns the average of a group of numeric values, rows, columns, or cells. Average excludes #missing and #error cells when obtaining the average.

Note:

The calculation does not include missing values regardless of whether they are suppressed.

Syntax:

Average(arguments)

or

Avg(arguments)

where arguments is one or more of the following values:

Argument	Description
numeric	A numeric value. For example, Average(10,20,30) returns the value 20. Numeric values can include decimals and negative values. See Numeric Arguments.
row, column, or cell reference	A pointer to a row, column, or cell within a grid. For example Avg(Grid1.row[4(3:5)]) returns the average of grid1, row segment 4, range 3 through 5.
function	An embedded function. See Mathematical Functions.

Examples:

Return the value 20:

Avg(10,30,20)

Return the average of all numbers that are part of three aggregate rows:

Average([1],[6],[8])

Calculate the average of aggregate row 3 and divide the average by 100:

Avg(row[3])/100