counta

Syntax:

Value Number  counta(Range source)

Description:

Returns the number of non-empty cells in source.

Examples:

($d4) = count($a1:$c3)
Before:
AB CD
114-
2apple1.234
3five%13
4
5
6
After:
AB CD
114-
2apple1.234
3five%13
48
5
6
($a1) = counta($b1:$d20)