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


How to Combine VLOOKUP and IFERROR to Replace the #N/A Error 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

Extracting Data with Excel’s LEFT Formula What does it do? It returns the first character or characters in a text string, based on the number of characters you specify. Formula breakdown: =LEFT(text, ) What it means: =LEFT(look in this cell, extract X characters) There are times when you will need t...
BETWEEN Formula in Excel There is no explicit Between formula in Excel, however we can come up with creative ways to create this functionality. Our goal is to evaluate if a given value is between a range, for example, is 6 between 1 and 10? We have three possible scenarios: numbers, dates, and text. ...
Count Text Occurrences with Excel’s SUBSTITU... What does it do? It replaces specific text in a text string i.e. Substitutes new text for old text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, ) What it means: =SUBSTITUTE(This cell, From this TEXT character, To this TEXT character, )...
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...