Count

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

Syntax:

Count(arguments)

where arguments is one or more of the following values:

Argument	Description
numeric	A numeric value. For example, Count(10,20,30) returns the value 3. 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. You can specify references in several ways. The reference syntax is: Count(GridName.GridElement[segment(range)].property . See Row, Column, or Cell Reference Arguments.
function	An embedded function. See Mathematical Functions.

Examples:

Return the count of three rows: 1, 6, and 8:

Count(row[1], row[6], row[8])

Return the count of 3 columns:

Count( column[E], column[G], column[I])

Calculate the count of two columns located on different grids:

Count( grid1.column[E], grid2.column[E])

Calculate the count of the cell located at row 4, column D:

Count(cell[D,4])

Calculate the count of aggregate row 3 in grid 5:

Count(grid5.row[3])