What does it do?

Counts the number of cells that are blank

Formula breakdown:


What it means:

=COUNTBLANK(range of cells to check)

Do you have a scenario where you want to count the number of cells that are blank in your Excel data?

If you are auditing your data and want to make sure that a blank cell is actually blank (and doesn’t contain an invisible character), then this formula is for you.

There is a simple way to count blank cells using Excel’s COUNTBLANK formula!

I explain how you can do this below:


STEP 1: We need to enter the COUNTBLANK function in a blank cell:


CountBlank Formula in Excel


STEP 2: The COUNTBLANK arguments:


What is the range of values that you want to check how many are blank?


CountBlank Formula in Excel


You now have your count of values that are blank! There are 3 blank values!

CountBlank Formula in Excel


CountBlank Formula in Excel



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Cleaning Data with Excel’s REPLACE Formula What does it do?Replaces part of a text string, based on the number of characters you specify, with a different text stringFormula breakdown:=REPLACE(old_text, start_num, num_chars, new_text)What it means:=REPLACE(this cell, starting from this number, all the ...
Remove Second Hyphen with Excel’s SUBSTITUTE... What does it do?Substitutes new_text for old_text in a text string.Formula breakdown:=SUBSTITUTE(text, old_text, new_text, )What it means:=SUBSTITUTE(This cell, By this text character, To this text character, )There are times where I needed to remove t...
Division Formula in Excel What does it do?Divides two numbersFormula breakdown:=number1 / number2What it means:=the number being divided / the number you are dividing byIn Excel dividing numbers together is really easy!The Division Formula is done through the use of the div...
10 + 1 Ways to Round Numbers in Excel This is a guest post by Alan Murray from Computergaga.There are many ways to round numbers in Excel. These techniques will typically involve formatting the values, or using formulas.This post will look at 10 rounding functions of Excel, and then look at some formatting te...