COUNTBLANK: Empty Cells, Empty Text and Zero in WPS Spreadsheet
Count blank cells with COUNTBLANK, including formula-empty text while excluding numeric zero. Build a precise six-cell example and a bounded completion calculation.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
COUNTBLANK counts cells treated as blank within a range. The official WPS lesson makes two important distinctions: a formula returning empty text ("") is counted, while a cell containing numeric zero is not counted. A visually empty result and a physically empty cell therefore need not be the same kind of cell, even when both contribute to this function.
Syntax
=COUNTBLANK(range)
Supply the range to inspect. This is one range argument, not a list of unrelated scalar values. The result is a count, not a list of missing-cell addresses or a count of incomplete records.
Build the example precisely
| Cell | Enter or leave |
|---|---|
| A2 | Leave genuinely empty |
| A3 | Enter the formula ="" |
| A4 | Enter numeric 0 |
| A5 | Enter text Ready |
| A6 | Leave genuinely empty |
| A7 | Enter numeric 12 |
Do not type the words “empty” or “blank” into A2 or A6. Those words would be text. Enter the formula in A3 rather than typing a pair of quote characters as ordinary text. Now calculate:
| Formula | Independently expected result |
|---|---|
=COUNTBLANK(A2:A7) |
3 |
=COUNTBLANK(A2:A3) |
2 |
=COUNTBLANK(A4:A5) |
0 |
=COUNTBLANK(A6:A7) |
1 |
=COUNTBLANK(A3) |
1 |
=COUNTBLANK(A4) |
0 |
A2 and A6 contribute two genuinely empty cells. A3 contributes one formula-empty result. Together they give three. Zero in A4 represents an actual numeric observation, so it contributes nothing to the blank count.
Practical case: monitor outstanding entries
Suppose the six positions A2:A7 are intended to receive responses. Under the lesson’s blank definition, three positions are blank and three are not blank, so the simple completed-position proportion is independently calculated as (6−3)/6 = 50%.
That interpretation is appropriate only when a formula returning empty text means “still outstanding” in your model. A formula may intentionally suppress a display for another reason. Similarly, a legitimate zero is a supplied value, but a placeholder zero may not mean a task is finished. Decide the business meaning before turning a blank count into a completion metric.
Errors, appearance and boundaries
A literal space, an imported null-like value, an error cell and a custom format hiding a number are not covered by the lesson’s two explicit special cases. This guide does not invent their WPS results. Avoid treating visual emptiness as sufficient evidence of the underlying value.
COUNTBLANK counts cells, so a row with two missing fields can contribute two; it does not count that row only once. It is also not a documented inverse of COUNTA for every cell type. The formula-empty distinction is a reason to inspect both definitions before combining them.
The lesson does not specify exact errors for malformed references or missing arguments. Use an explicit valid range and check that it excludes headings, spare template rows and unrelated output cells. A large preallocated range can otherwise report many legitimate unused positions as blanks.
Availability and evidence
The official WPS lesson is dated 2019-05-24 and explicitly labels its applicability WPS Office for Windows Personal. It does not identify a numeric release. This establishes documentation by that date, not the function’s original introduction or its last working version. Current build limits and equivalence across WPS clients remain unverified. The available evidence does not establish retirement or formal deprecation.
Checked October 18, 2026. The examples in this guide are original, independently calculated controls based on the lesson. They have not been run in WPS or another spreadsheet application. No screenshot or execution result is claimed.