COUNTBLANK Function in Excel

COUNTBLANK Main Cover Image

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.

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.

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

Uses

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:

=COUNTBLANK(range)

COUNTBLANK Syntax Image-0

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

Notes

  • 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

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.

COUNTBLANK Function Image-i

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

COUNTBLANK Function Image-ii

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

COUNTBLANK Function Image

Leave a Reply