COUNTBLANK
Statistical
Counts the number of empty (blank) cells in a range.
Translations
EnglishCOUNTBLANK
FrenchNB.VIDE
SpanishCONTAR.BLANCO
GermanANZAHLLEEREZELLEN
ItalianCONTA.VUOTE
PortugueseCONTAR.VAZIO
DutchAANTAL.LEGE.CELLEN
PolishLICZ.PUSTE
RussianСЧИТАТЬПУСТОТЫ
TurkishBOŞLUKSAY
CzechCOUNTBLANK
HungarianDARABÜRES
SwedishANTAL.TOMMA
DanishANTAL.BLANKE
FinnishLASKE.TYHJÄT
Syntax
COUNTBLANK(range)Arguments
rangeRange to check for blanks
Examples
=COUNTBLANK(A1:A100)Empty count
Counts blank cells
=ROWS(A:A)-COUNTBLANK(A:A)Non-blank count
Cells with data
=IF(COUNTBLANK(A1:E1)>0,"Incomplete","Complete")Status check
Validates form completion
Tips & Best Practices
- •Cells with formulas returning empty are counted
- •Cells with spaces are NOT blank
- •Useful for data validation
Common Mistakes
- •Expecting COUNTBLANK to count cells with an empty-looking formula result, like a formula returning "" - it doesn't, that's technically text, not blank
- •Using COUNTBLANK on a range that was ever touched by a formula or paste operation, since a cell that looks empty can still hold leftover formatting or a zero-length string
- •Confusing COUNTBLANK's count with COUNTA's - one counts what's missing, the other counts what's there, and mixing them up skews any summary based on total row count
Related Functions
Frequently Asked Questions
Does COUNTBLANK count a cell with a formula that returns an empty string?
No - a formula returning "" is technically text, not a true blank, so COUNTBLANK doesn't count it, even though the cell looks empty.
How do I count blanks and empty-looking formula results together?
Use COUNTIF(range,"") instead, which catches both true blanks and cells that evaluate to an empty string.
Can COUNTBLANK be used across multiple non-adjacent ranges?
Not directly in one call - it only accepts a single range, so add separate COUNTBLANK calls together for multiple ranges.
Need to translate a formula using COUNTBLANK?
Use our translator to convert your complete formula