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

CountBlank Formula in Excel | MyExcelOnline CountBlank Formula in Excel | MyExcelOnline

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  Sum the Last 7 Transactions with the Offset Function

CountBlank Formula in Excel

 

If you like this Excel tip, please share it
CountBlank Formula in Excel | MyExcelOnline CountBlank Formula in Excel | MyExcelOnline
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!

Share to...