Spreadsheet Practice

COUNTBLANK function

Quick answer

COUNTBLANK counts the empty cells in a range: unassigned tasks, unanswered questions, missing dates.

Syntax
=COUNTBLANK(range)
Most common use
=COUNTBLANK(B2:B6) returns 2 (Tasks nobody has picked up yet)

It also treats a formula that returns empty text ("") as blank. A cell with a space or a zero is not blank, so it isn't counted.

Available in
Every current version
Category
Statistical functions
Returns
The number of empty cells in the range.
Google Sheets
Also available in Google Sheets.

Syntax

=COUNTBLANK(range)

ArgumentRequired?What it is
rangeRequiredThe range to check for empty cells.

Examples

Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.

CellFormulaResultWhat it shows
F2=COUNTBLANK(B2:B6)2Tasks nobody has picked up yet
F3=COUNTBLANK(C2:C6)2Tasks without a due date
F4=COUNTBLANK(B2:C6)4Gaps across both columns at once

Try it live

This is the sample sheet. Change any number or text, or edit a formula, and the results update.

Show the sample data as a table
TaskOwnerDue dateCheckResult
Draft budgetAna6/3/2026No owner2
Book venue6/10/2026No due date2
Order badgesLeeBlanks in both4
Send invites
Print agendaKim6/12/2026

Practice COUNTBLANK

Graded instantly, then re-checked on changed data.

Steps left per order

Each order should have a date in all four steps. In F2, count how many steps are still blank for order SO-501. Fill down to F6.

Common mistakes

What you seeWhy, and how to fix it
A cell that looks empty isn't countedIt contains a space or another invisible character. Clear it with Delete, or check it with =LEN(cell).
Zeros aren't counted as blankA 0 is a value. Use COUNTIF(range,0) to count zeros separately.

Tips

  • Use =COUNTBLANK(B2:E2)=0 in a helper column to flag rows that are complete.

Questions

Does COUNTBLANK count cells with formulas that return ""?

Yes. A formula that returns empty text is counted as blank.

How do I count non-blank cells instead?

Use COUNTA, or subtract COUNTBLANK from the total number of cells with ROWS(range)*COLUMNS(range)-COUNTBLANK(range).

Answers that use COUNTBLANK

In other languages

COUNTBLANK is CONTAR.BLANCO in Spanish Excel and ANZAHLLEEREZELLEN in German Excel. Each page has the syntax with semicolons, the examples and the exercise in that language. For other functions and languages, use the Function Translator.

Updated Checked by running: every formula on this page was run by our formula engine on .