CountA

CountA is a mathematical function that returns the number of values in a group of numeric values, rows, columns, or cells. CountA includes #missing and #error cells when obtaining the count only for rows or columns that are not suppressed.

Syntax:

CountA(arguments)

where arguments is one or more of the following values:

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

Argument

Description

numeric

A numeric value. For example, CountA(10,20,30,50) returns the value 4.

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.

References can be specified in several ways. The reference syntax is: CountA(GridName.GridElement[segment(range)].property. See Row, Column, or Cell Reference Arguments.

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 four rows:

CountA([1:4])

Return the count of four rows:

CountA(row[1], row[6], row[8] row[where data yields #error])