count
Count numeric values in the arguments.
Syntax
Section titled “Syntax”v = count(value1, value2, ...)Description
Section titled “Description”Returns the number of cells / scalars in the arguments that contain numbers. Text, logical, and empty cells are not counted.
Example
Section titled “Example”count(1, 'a', 2, '', 3) % 3See also
Section titled “See also”counta— Count non-empty values in the arguments.countblank— Count empty cells in a range.countif— Count cells in a range that meet a criterion.countifs— Count cells meeting multiple criteria.