How to use COUNTBLANK function in Microsoft Excel


In this article, we will talk about COUNTBLANK function that belongs to COUNT family. The COUNT family counts the number of cells depends on the criterion value within the range or list of supplied arguments and returns the number as the result.

There are many features that makes Microsoft Excel so user friendly and robust. Some of them are its in-built functions that gives flexibility to users to play with spreadsheet. The spreadsheet can store large amount of data and can perform calculations, basic math and many more.

The COUNTBLANK function counts and returns the number of empty cells available in the selected range or list of arguments.

Use of COUNTBLANK Function               

This function is usually used to count the number of the cells that are empty or don’t contain any type of value within the provided range or list of argument.

Syntax & Arguments:


range – It is required and It is the range of cells in which you want to count the blank cells.


  • Cells that contain an empty text or a formulas that return empty text (“”), are considered as blank and counted by the function.
  • Cells with zero values are considered not blank and will not be counted.
  • Cell that contains an error value or a formula returning an error value, is not considered blank and not counted by the function.


Example – COUNTBLANK Function

Let’s look at the following example. We have taken a sample data that contains some values in column A. And, we have to find out how many cells in the following data are empty.

Example - Countblank Function
Example – Countblank Function

But before we move further, take a look at cell A7, which contains empty text string.

CountBlank Function
CountBlank Function

And, when range is supplied in the function, function returns 2 as the number of cells that are empty within the range.

Count Empty Cells
Count Empty Cells



Related Excel Functions


More Useful Articles


Related Video


Please enter your comment!
Please enter your name here