COUNTA function

COUNTA counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.


COUNTA(value1, value2, ...value30)

value 1, value 2, and so on, up to value 30 are 1 to 30 arguments representing the values to be counted.


The entries 2, 4, 6 and eight in the value 1-4 fields are to be counted.

=COUNTA(2,4,6,"eight") = 4. The count of values is, therefore, 4.