COUNTBLANK counts the gaps: cells that are truly empty, plus cells whose formula evaluates to empty text (""). It is the complement of COUNTA — together they add up to the number of cells in the range. A cell containing a space, a zero or an error is NOT blank, which is the distinction that trips most people up.
Returns a number. Counts empty cells and "" formula results; spaces, zeros and errors are not blank.
Only true emptiness counts. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =COUNTBLANK(A2:A8) | 1 | The single empty score cell |
| =COUNTBLANK(C2:C8) | 0 | No empty labels |
| =COUNTBLANK(A2:C8) | 1 | One gap across the block |
| =COUNTA(A2:A8) | 6 | Non-empty complement |
| =COUNTBLANK(B2:B8) | 0 | Sales column is full |
| =ROWS(A2:A8)-COUNTA(A2:A8) | 1 | Total minus non-empty |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to count gaps and cross-check against COUNTA.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
COUNTBLANK is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
COUNTBLANK is one piece. The full course walks the toolkit end to end with live, measured examples.