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:

CountBlank Formula in Excel | MyExcelOnline


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