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
${formula}	1	Single defined cell.
${formula}	0	Cell in C1 has no value.
${formula}	4	Range contains only 4 defined cells in A1, B1, A2 and B2.
${formula}	4	Same as before but using multiple ranges.