The COUNTA function counts the number of cells in a range, that are not empty.
It is sometimes being confused with its sibling COUNT function.
The difference between them is that the COUNTA function counts cells that contain any type of data, while the COUNT function generally counts only cells containing number values.
Its syntax is similar to the COUNT function:
v1, v2, … : They are the cell references or cell ranges within which you want to count numbers.
COUNTA(v1, [v2])
v2, … : Optional arguments that can be up to a maximum of 255
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here are some video examples of possible uses of COUNTA:
In the cell A1 enter a function that counts non blank cells for the cell range A3:A15000.
Also, in the cell C116 enter a function that returns the number of cells that contain numbers for the cell range C3:C110 and in the cell C117 enter another function
Insert a function in the cell A1 to count non blank cells within the cell range A3:A15000.
Use the appropriate function to display in the cell B17 the total of modules existing within the cell range A4:A14.