Skip to main content
Version: Streamsheets 3.0

COUNTA

Counts the number of defined cells in a given range.

Syntax

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

Arguments

NameTypeDescription
Value1RangeCell or range to check for defined cells.
Value2...ValueN (optional)RangeAdditional cells or ranges to check.

Return

TypeDescription
NumberAmount of defined cells.

Examples

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