CountBlank formula

It will help you in counting the number of cells that are blank in your Excel sheet. 

The breakdown for CountBlank Formula:



=COUNTBLANK(range of cells to check)

If you’re having a sheet in which you want to count the number of cells that are blank in your Excel, then CountBlank will be very helpful for you.

Previously In Excel Formulas: How to use CountIfs Formula in Excel?

While auditing your Excel data if you need to make sure that a blank cell remains blank and doesn’t even contain any invisible characters then you must use CountBlank formula for same. 

Follow these explained steps for applying CountBlank Formula in your Excel.

STEP 1: Firstly, go to a blank cell of your Excel sheet and enter the COUNTBLANK function like this:


CountBlank formula

STEP 2: Now you need to enter The COUNTBLANK arguments:


Here range means that you need to enter the range of values or cells, from which it’s needed to check how many of them are blank.


CountBlank formula

There you go with your count of values that are blank in a sheet of your Excel data. here in my given example, there are 3 blank values or cells.

CountBlank formula