COUNT(list)

The COUNT function counts the number of items of non-blank entries in list. The list can contain numbers, cell addresses, ranges, and cell names.

For example:

COUNT(A1..A10)

returns a count of the number of cells A1 through to A10 that are non-blank.

Note that if a cell contains a formula that returns a blank value (for example CONCATENATE(" ")), then Ability does not regard the cell itself as blank.

See also:

Other statistical functions