COUNTA

Explanation

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.

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…

Practice COUNTA function

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