# COUNTBLANK function in Excel

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

Source: https://spreadsheetpractice.com/functions/countblank · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** 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)
- **Available in:** Every current version
- **Category:** [Statistical functions](https://spreadsheetpractice.com/functions/category/stats)
- **Returns:** The number of empty cells in the range.
- **Google Sheets:** Also available in Google Sheets.

## What it does

COUNTBLANK counts the empty cells in a range: unassigned tasks, unanswered questions, missing dates. 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.

## Syntax

`=COUNTBLANK(range)`

| Argument | Required? | What it is |
|---|---|---|
| `range` | Required | The range to check for empty cells. |

## Examples

Each result was calculated by running the formula on the sample sheet.

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

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Task | Owner | Due date |  | Check | Result |
| 2 | Draft budget | Ana | 6/3/2026 |  | No owner | 2 |
| 3 | Book venue |  | 6/10/2026 |  | No due date | 2 |
| 4 | Order badges | Lee |  |  | Blanks in both | 4 |
| 5 | Send invites |  |  |  |  |  |
| 6 | Print agenda | Kim | 6/12/2026 |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| A cell that looks empty isn't counted | It contains a space or another invisible character. Clear it with Delete, or check it with =LEN(cell). |
| Zeros aren't counted as blank | A 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.

## Related functions

- [COUNTA](https://spreadsheetpractice.com/functions/counta): COUNTA counts every cell that isn't empty: text, numbers, dates, errors and even formulas that return empty text.
- [COUNT](https://spreadsheetpractice.com/functions/count): COUNT tells you how many cells contain numbers.
- [ISBLANK](https://spreadsheetpractice.com/functions/isblank): ISBLANK returns TRUE when a cell is completely empty.

## 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).

## Practice

A graded COUNTBLANK exercise ("Steps left per order") is on [the COUNTBLANK page](https://spreadsheetpractice.com/functions/countblank). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
