counta
Count non-empty values in the arguments.
Syntax
Section titled “Syntax”v = counta(value1, value2, ...)Description
Section titled “Description”Returns the number of arguments that are not empty — counts numbers, text, logicals, and errors. Only blank cells are excluded.
Example
Section titled “Example”counta(1, 'a', '', 2) % 3See also
Section titled “See also”count— Count numeric values in the arguments.countblank— Count empty cells in a range.countif— Count cells in a range that meet a criterion.