How To Use Excel COUNTBLANK Function –A Complete Tutorial

Given a set of data, we might want to find out the count of all the blank cells from a particular range.

Excel COUNTBLANK function can be of used to achieve the same.

Let’s see how to do it…!!!

1. What is the COUNTBLANK Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is the COUNTBLANK Function?

The COUNTBLANK function can be used to count the number of cells that are blank such that not numbers, text, logical values, error values, and empty text (“”).


2. What is the Syntax?

=COUNTBLANK(range)

  • range = [Required] range within which you want to count.

Note :

  • Cells that contain numbers, text, logical values, error values will not be counted.
  • Cells containing empty text (“”) will be counted.

3. How to use it with an example?

Let’s have a look at a few scenarios where COUNTBLANK function can be applied.

Let’s find the count…

1. Finding the count of cells which contains blank values.
2. Finding the count of cells which contains blank values and an empty string.

1. Finding the count of cells which contains blank values

Excel COUNTBLANK function 1.PNG

=COUNTBLANK(B2:B7)

Gives the count of all blank cells, neglecting the non-empty cells in the range.


2. Finding the count of cells which contains blank values and an empty string

Excel COUNTBLANK function 2.PNG

=COUNTBLANK(B2:B7)

Gives the count of all blank cells and empty strings while neglecting the non-empty cells in the range.

 

Hope it has helped you… 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: