COUNTA

Counts the number of defined cells in a given range.

Syntax

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

Arguments

Name	Description
Value1	Cell or range to check for defined cells.
Value2...ValueN (optional)	Additional cells or ranges to check.

Return

Amount of defined cells.

Examples

	A	B	C
1	42	hi
2	FALSE	0

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