Aggregate Property Argument

An aggregate row, column, or cell contains multiple rows, columns, or cells, respectively.

The aggregate property argument is the last argument in the following mathematical function syntax:

FunctionName(GridName.Gridelement[segment(range)].property)

You apply the following aggregate properties to a row, column, or cell reference.

Table B-4 Aggregate Properties

Properties	Description
Average	Returns the average of a row, column, or cell. The calculation excludes #MISSING and #ERROR values.
AverageA	Returns the average of a row, column, or cell. The calculation includes #MISSING and #ERROR values.
Count	Returns the number of values in a row, column, or cell. The calculation excludes #MISSING and #ERROR values.
CountA	Returns the number of values in a row, column, or cell. The calculation treats #MISSING and #ERROR values as zero (0).
Max	Returns the maximum value of a row, column, or cell
Min	Returns the minimum value of a row, column, or cell
Product	Returns the product of rows or columns
Sum	Returns the sum of a row, column, or cell

When used as a mathematical function argument, the default for property is the same as the function. In the following example the default property is Average:

Average(row[2])

When not used as a mathematical function argument, the default for property is sum. In the following example the default property is the sum of an aggregate row:

row[2]