This function calculates the number of empty cells within a specified range. Unlike COUNT() and COUNTA(), it specifically tallies blank cells.
Syntax
COUNTBLANK(range)
Arguments
- range(required): The cell range to evaluate for empty cells
Background
Particularly valuable for:
- Data validation and completeness checks
- Large datasets where manual counting would be impractical
- Complementing COUNT() and COUNTA() to provide complete cell analysis
Key Features
- Counts truly empty cells (no data or formulas)
- Also counts cells containing:
- Formulas that return empty strings (« »)
- Formulas that return NULL values
- Does not count cells with:
- Space characters
- Zero values
- Text strings (even if blank-appearing)
Example
Using the same data range (C3:C25) from the COUNT() function example:
=COUNTBLANK(C3:C25)
Returns: 3
Interpretation
This indicates there are 3 completely empty cells in the range C3:C25. When combined with COUNTA() results (which returned 19 for the same data), you can verify complete data coverage:
- 19 cells with data (COUNTA)
- 3 empty cells (COUNTBLANK)
- Total of 22 cells accounted for (matches range size)
Practical Application
Useful for:
- Identifying missing data entries
- Tracking form completion status
- Validating data imports
- Monitoring data collection progress