COUNTA function allows us to count all items in a range – textual and numeric items. This is why the function is called COUNTA – The A stands for “All”. This is in contrast to COUNT function, which counts only numeric values.



For value1 we will use a cell range – for example, to count the cells in range A1:D4, we will type:


We can use this function to check multiple ranges, by typing additional range in [value2], [value3] etc…

Practice COUNTA function

Now, let’s practice COUNTA function to count the following cells: