With COUNTA you can count all items in a Range with COUNTA, both Text and Numbers.


This function counts both textual and numeric items. It 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…

learn more about COUNTA here


Practice COUNTA function

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


Want to practice COUNTA and more? check out our unique Excercises page where you can learn, practice and become a master!