COUNTA functionAdded by IBM on December 11, 2013 | Version 1 (Original)
|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.
, 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.
= 4. The count of values is, therefore, 4.
Parent topic: List of functions