Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.


This lesson will go through the COUNTA function, which counts the number of nonblank cells in a defined area. COUNTA is short for count all.

It consists of only one argument, the range within which we will count the non-blank cells.
We type in the Equals, CountA, and select the area.

The result is that there are 6 cells in the selected area which have content.
In this lesson we have shown how to use the function which Counts the non-blank cells in a given range.