An easy way to count cells that are not empty in Excel

Let’s say you want to count cells that contain the number of employees in a data range, and would like to ignore any blank cells. The way to go about doing this is to use the COUNTA function.

The COUNTA function is a way to count cells containing any type of information, including error values and empty text (“”). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.

You are welcome to download the workbook to practice.

Applies To: Microsoft® Excel® 2010, 2013 and 2016.

1.To count the total number of employees in the data range A3:A19.

  • Select cell A20.
  • Type =COUNTA(A3:A19)
  • Press Enter.
  • The answer will be 15.


2. The COUNTA function returns 15 and ignores blank cells in the range A3:A19.

Instead of manually counting the cells that are not empty, you can use the COUNTA function to get an accurate result quickly and easily.