Download Excel Workbook
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:
STEP 1: We need to enter the COUNTBLANK function in a blank cell:
=COUNTBLANK(
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)
You now have your count of values that are blank! There are 3 blank values!
Bryan
Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).
He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.
