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.
function	An embedded function. See Mathematical Functions.

Examples:

If a grid has four rows with the values 10, 20, 30, and #error, the following formula in the 5th row returns the count of three rows:

Count([1:4])

Return the count of three rows:

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