What does it do?

Counts the number of cells that are blank

Formula breakdown:

=COUNTBLANK(range)

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

DOWNLOAD EXCEL WORKBOOK

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

=COUNTBLANK(

CountBlank Formula in Excel

 

STEP 2: The COUNTBLANK arguments:

range

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

=COUNTBLANK(B9:C12)

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

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn