Skip to main content
Version: Streamsheets 2.4

COUNTA

Counts the number of defined cells in a given range.

Syntax

=COUNTA(Value1, [Value2, ..., ValueN])

Arguments

NameDescription
Value1Cell or range to check for defined cells.
Value2...ValueNOptional. Additional cells or ranges to check.

Return Value

Amount of defined cells.

Example

ABC
142hi
2FALSE0
FunctionResultComment
=COUNTA(A1)1Single defined cell.
=COUNTA(C1)0Cell in C1 has no value.
=COUNTA(A1:C3)4Range contains only 4 defined cells in A1, B1, A2 and B2.
=COUNTA(A1:B1,A2:B2)4Same as before but using multiple ranges.