COUNTN(list)

The COUNTN function counts how many numbers there are in a list of arguments. The arguments can also be ranges.

For example:

COUNTN(A1..A10)

returns a count of the number of cells A1 through to A10 containing a number, a formula with a numeric result or a date.

See also:

Other statistical functions