Skip to main content
Version: Streamsheets 2.5

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...ValueN (optional)Additional cells or ranges to check.

Return

Amount of defined cells.

Examples

ABC
142hi
2FALSE0
FormulaResultComment
=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.