The Counta function counts how many of the cells given are non-empty.
|1||Value||Either a value or a range/array of multiple values.|
|2||…||Any number of more values or ranges/arrays of multiple values. Up to 255 can be given.|
Here’s an example that you can try for yourself. It’ll also show the difference between Count and CountA.
Use the Counta function in cell D2 and apply it to cells A1 to A5 in the spreadsheet editor below.
Note that you can click the Show Answer button to look at the answer if you cannot figure it out.
=COUNTA(A1:A5) to count the number of cells that contain a value. The argument, A1:A5, is the range of cells that we count. So cells A1, A2, A3, A4, and A5. Each of these cells contains a value, therefore the result is 5.
It stands for Count All.
The count function will not count empty cells.
It will count everything else, including text and errors. It also counts empty text that could, for example, be returned by a formula.
To count only empty cells you can use the CountBlank function.
Note that this function also counts cells that contain empty text returned by a formula. So both Counta and CountBlank count cells with empty text.
Use the Count function to count only numbers.
Use the CountBlank function to count only blank cells.
Use the CountIf function to count other specific types of values.