COUNTA
With COUNTA you can count all items in a Range with COUNTA, both Text and Numbers.
Explanation
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.
Syntax
=COUNTA(value1,[value2],[value3]…)
For value1 we will use a cell range – for example, to count the cells in range A1:D4, we will type:
=COUNTA(A1:A4)
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!