Count Blank Cells - COUNTBLANK Function

Today in this article I will discuss about the excel function COUNTBLANK, a very small inbuilt function in Microsoft Excel.

In the last article, we discussed about How to Count Not Blank Cells in Excel.

In this article, we will learn How to Count Blank Cells, in some compound formula it becomes necessary to learn these small functions to simplify the existing excel formula.

Let us first discuss about COUNTBLANK then we will discuss where can we use it and how we can implement this function.

Description

As the name suggest the Microsoft Excel COUNTBLANK function counts the number of cells that are empty.

Note : As COUNTBLANK count the cells that are blank, if any space is present in any cell it will not be counted because space is also a character and space ‘alone’ is not visible to bare eyes. Therefore, it is better to use TRIM function while using COUNTBLANK Function if you are not sure that all visible empty cells are not containing any ‘space’.

Syntax

The syntax for the COUNTBLANK function in Microsoft Excel is:

=COUNTBLANK(range)

Parameters or Arguments

range

The range of cells to count empty cells.

Returns

The COUNTBLANK function returns a numeric value.

How to use COUNTBLANK Function in Excel ?

1.   Select a cell, then

2.   Type ‘=’ sign in that cell or in the formula bar

3.   Type ‘COUNTBLANK(‘ or type COU, a drop down list will appear, select COUNTBLANK, press TAB button

4.   Select the range or alternatively you can type the range as we do in the basic SUM function. Hit enter.

5.   Done.

How to use COUNTBLANK function to count Blank cells in Excel

How to use COUNTBLANK & COUNTA function to count Blank and Not Blank cells in Excel

We can use COUNTBLANK nested with other functions like INDEX or SUMPRODUCT, we will discuss it in another article in details with examples.

I hope this article is informative & you enjoyed this article.

Thank you for reading…