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

Getting the remainder with Excel’s MOD Formu... What does it do? Gives you the remainder after dividing one number with another Formula breakdown: =MOD(number1, number2) What it means: =MOD(a number, divided by this number) In Excel it is very easy to divide two numbers. But how about if you need to ge...
Add Leading Zeros in Excel Do you have a lot of numbers with an uneven number of digits in your Excel list? Do you want to make them uniform by adding leading zeros to them? Well, it's a pain to add zeros in front of them one by one! Thankfully, Excel allows you to add leading zeros with one singl...
CountIfs Formula in Excel What does it do? Counts the number of cells that matches your specified conditions Formula breakdown: =COUNTIFS(range1, criteria1, , , ...) What it means: =COUNTIFS(range of cells to check1, condition to check against1, , , ...) Do you have a scenario where ...
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, )...