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:

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 RESOURCE:

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials