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!