COUNTBLANK
Counts empty cells in a range: how many form fields are left blank, how many days on a timesheet have no entry.
COUNTBLANK(range)- range
- Where to look for empty cells, for example B2:D2. One range only.
Return value
The number of empty cells. A cell with a formula that returned empty text "" also counts as empty.
Examples
How many fields are blank
fx
A
B
C
D
E
F
1
2
3
4
5
6
7
Client
Email
Phone
City
Blank
Acme Corp
info@acme.com
555-0142
Boston
Smith Consulting
smith@mail.com
Denver
Vector Inc
Austin
Progress LLC
office@progress.com
555-0187
Sheet1
Details
COUNTBLANK takes one range and returns how many empty cells it has. Zero doesn’t count as empty: it’s a value.
It’s the flip side of COUNTA: in a range of 3 cells, empty and filled together add up to 3.
Common mistakes
- A cell with a space looks empty, but COUNTBLANK won’t count it.
- You can’t list several ranges separated by commas: the function takes a single argument.