Summary

COUNTBLANK returns how many cells in a range are blank. It is a simple way to measure what is missing instead of what is present.

This can be more useful than it sounds. If a sheet tracks responses, statuses, or required fields, the blank count tells you how many items still need work before the data is complete.

Syntax

=COUNTBLANK(range)

This function takes one range and checks it for blank cells.

Arguments

• range - [required] The cells you want Excel to examine for blanks.

COUNTBLANK vs Other Functions

Using the COUNTBLANK Function

COUNTBLANK is most useful when blank cells have meaning. In a form, a blank cell can mean no response. In a project sheet, it can mean unfinished work. In a customer table, it can mean missing contact details. Instead of scanning down the sheet yourself, you can let Excel count those gaps for you.

Microsoft notes an important detail here. Cells with formulas that return "" are counted as blank by COUNTBLANK. Cells containing zero are not blank. A cell that contains a space character also is not blank, even if it looks empty on the screen. That is often the reason a blank count looks lower than expected.

Because of that rule, COUNTBLANK is also useful in cleanup work. If your dataset has hidden spaces or values that only look empty, the function can help you spot the difference between a truly blank cell and a cell that still contains something.

Example 1 - Count blank cells in a response list

This works well for sign-up lists, attendance columns, and simple forms where blanks mean no answer yet.

=COUNTBLANK(B1:B10) // Returns how many cells in the range are blank.

Example 2 - Check a smaller status range

A short count like this is useful when you only want to see how many rows still need an update.

=COUNTBLANK(A1:A3) // Returns the number of blank cells in the range.

Example 3 - Compare real blanks with cells that only look empty

Cells with spaces behave differently from cells that are actually blank, so this kind of check is useful during cleanup.

=COUNTBLANK(C1:C10) // Counts true blanks in the range.

Example 4 - Measure missing records before reporting

If you want to know how much data is still missing before a report goes out, COUNTBLANK gives you a quick answer.

=COUNTBLANK(B1:B10) // Returns the number of missing entries in the range.

Conclusion Recap

• Main job: COUNTBLANK counts blank cells in a range.
• Useful for missing data: It helps measure how incomplete a list still is.
• Formula blanks count: A formula that returns "" is treated as blank.
• Spaces do not count as blank: A cell with a hidden space is still considered filled.
• Zero is not blank: Numeric zero stays excluded from the blank count.
• Related check: Use COUNTA if you want the opposite view and need to count filled cells.