COUNTA

Counts the number of defined cells in a given range.

Syntax

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

Arguments

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

Return

Type	Description
Number	Amount of defined cells.

Examples

	A	B	C
1	42	hi
2	FALSE	0
3

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.