COUNTA

Count non-empty cells.

Parameter List

Syntax
COUNTA(value1
[value2]
)
value1

A value, cell, range, or JSON array in which to count the occurence of numbers or text strings. For example: A1:B5.

[optional] value2

Additional value, cell, range, or JSON array in which to count the occurence of numbers or text strings. For example: C1:D5.

Examples

COUNTA(A1:A4) returns 4 as all cells in the range have values in them.Example 1