How to Count Blank Cells in Google Sheets With COUNTBLANK

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: COUNTBLANK counts the empty cells in a range. The formula is =COUNTBLANK(value1, [value2, ...]). Cells with no content and cells holding an empty string "" both count as blank.

What COUNTBLANK does

COUNTBLANK answers "how many cells are missing?" It is the mirror image of COUNTA, which counts the cells that have something in them. Use it to spot incomplete forms, missing phone numbers or unfilled rows.

COUNTBLANK syntax

=COUNTBLANK(value1, [value2, ...])

Each argument is a value or range to check. Google's help page states that COUNTBLANK treats cells with no content, and cells containing an empty string "", as blank. That second case matters: a formula that returns "" looks empty and is counted as blank.

A step-by-step example

Here is a contact list in cells A1:B6. Some names and phone numbers are missing.

AB
1NamePhone
2Ann111
3222
4Ben
5444
6Cara
=COUNTBLANK(A2:A6)

This returns 2: the names in A3 and A5 are missing. To check both columns at once, pass the whole block:

=COUNTBLANK(A2:B6)

This returns 4: two missing names and two missing phone numbers.

COUNTBLANK vs COUNTA

For a range of 5 cells, COUNTA plus COUNTBLANK should add up to 5 when every blank is truly empty. If they do not, some cells probably hold values that look empty, such as a space. A space is not an empty string, so COUNTBLANK does not count it.

Common mistakes

Try it yourself

Use the table above (A1:B6). Type your formula into the box, starting with =, then press Check.

Exercise 1: Missing names

Write a formula that counts the blank cells in the Name column, A2:A6.

Hint: one range argument.

Exercise 2: Whole block

Write a formula that counts the blank cells in the whole block A2:B6.

Hint: use the two-column range.

What to learn next

Syntax and rules in this guide were checked against Google's COUNTBLANK help page. See all guides.