COUNTBLANK
Count how many cells in a range hold nothing.
Syntax
COUNTBLANK(range)| Argument | Required | Description |
|---|---|---|
range | Required | The range to examine. |
Examples
Every example below was executed against VisiGrid engine 0.31.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=COUNTBLANK(A1:A5) | 1 | |
=COUNTA(A1:A5) | 4 | The two together account for the whole range. |
Finding gaps in data
The usual job is validation — how many rows are missing a required field:
=COUNTBLANK(B2:B1000)Non-zero means someone has work to do, and it is a better check than eyeballing a long column.
COUNTBLANK and COUNTA always sum to the size of the
range, so either one tells you the other. Use whichever makes the sentence read
correctly — “12 rows missing a value” or “988 rows complete”.
Excel compatibility
Matches Excel.