How to use COUNTBLANK function in Microsoft Excel

0
128

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:

=COUNTBLANK(range)

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 – 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

AVERAGE | SUM | MIN | MAX

More Useful Articles

COUNT | COUNTA | COUNTIF | COUNTIFS

Related Video

LEAVE A REPLY

Please enter your comment!
Please enter your name here