Quick Navigation

COUNTBLANK Function

Excel 2007+

Summary

The COUNTBLANK function is a statistical tool that counts empty cells within a specified range, making it essential for data cleaning and validation tasks in Excel spreadsheets.

Syntax

COUNTBLANK(range)

Parameters

Parameter	Type	Required	Description
range	`Range`	Yes	The contiguous or non-contiguous range of cells to count for empty values

Using the COUNTBLANK Function

COUNTBLANK helps identify missing data in datasets by counting cells that appear empty. It's particularly useful before analysis to quantify data completeness and locate gaps in your data entry.

Common COUNTBLANK Examples

Basic Empty Cell Count

=COUNTBLANK(A1:B5)

Counts all empty cells within the range A1:B5, returning the total number of blanks.

Mixed Data Range

=COUNTBLANK(C2:E10)

Analyzes a table with text, numbers, and formulas - counts only truly empty cells and those with "" formula results.

Frequently Asked Questions

Yes, cells containing formulas that evaluate to "" (empty text) are counted as blank.

No, cells with the value 0 are not considered blank and are excluded from the count.

Common Errors and Solutions

#VALUE! error

Cause: The range argument contains non-range values like text or numbers instead of a proper cell reference

Solution: Ensure the range parameter references actual cells, e.g., A1:B10 instead of text strings

Notes

COUNTBLANK ignores cells with spaces, zeros, or any non-empty content
Use with COUNTA and COUNT to get complete cell population analysis
Non-contiguous ranges supported using standard Excel range syntax

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003, Excel XP, Excel 2000, Excel 97

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+