COUNTA

Counts the number of cells that are not empty in the specified cell or cells, and the items in the lists.

Syntax

COUNTA( [Any value1], [Any value2], ... ) → Integer

Parameters

value1
value2
…

Zero or more items to include in the counting.

Remarks

Counts the number of non-blank values in the supplied list. A value is non-blank if it contains any content of any type, including an error. In a reference, every cell that is not empty is included in the count. In arrays, all elements that are not blank are included. An empty text value ("") is not considered blank. Errors values are counted and do not cause the function to return an error (that is, this function does not propagate errors). To exclude error values, logical values, and text representations of numbers in a reference as part of the calculation, use the COUNT function.

If there are no arguments provided, the function returns zero.

Example

Formula

=COUNTA(A1:B5)
=COUNTA(3,"1",A1,B2:B5,{1;2})

See Also

Function Reference
COUNT Function
ISBLANK Function