Functions
COUNTBLANK
Count blank/empty cells
Try it
When to use it
When should I use COUNTBLANK instead of COUNTA?
Use COUNTBLANK to count the empty cells in a range; use COUNTA to count the cells that contain something. They are complements of each other.
Does COUNTBLANK count cells that hold an empty string?
Yes — a cell holding an empty string ("") is treated as blank by COUNTBLANK, even though it is not truly empty.
Use cases
Find how many cells in a column are still blank
Count missing values where most entries are empty
Used in
Syntax
COUNTBLANK(range)Examples
=COUNTBLANK({1,"",3,"",5}) // => 2
=COUNTBLANK({"","",""}) // => 3
=COUNTBLANK({1,2,3}) // => 0