Pinterest Pixel

CountBlank Formula in Excel

What does it do? Counts the number of cells that are blank Formula breakdown: =COUNTBLANK(range) What it... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

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 workbookCOUNTBLANK.xlsx

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

=COUNTBLANK(

CountBlank Formula in Excel

 

STEP 2: The COUNTBLANK arguments:

Table of Contents

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!

See also  HOUR Formula in Excel

CountBlank Formula in Excel

 

CountBlank Formula 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

CountBlank Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!