COUNTBLANK Function (Gnumeric)
Learn the COUNTBLANK function in Gnumeric: Counts the blank cells in a specified range.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Gnumeric. How formula examples are checked
Quick answer
COUNTBLANK counts genuinely blank cells in a selected rectangular range. It is useful for identifying missing entries in a data-entry column.
Gnumeric syntax and parameters
=COUNTBLANK(range)
range — The contiguous range whose empty cells are to be counted, for example B2:B12.
Version and locale scope: The release-scoped function registry confirms COUNTBLANK within the Gnumeric 1.12.62 standard public function set (September 2026). The Gnumeric manual documents the syntax shown here but is a continuously updated reference, not a frozen 1.12.62 manual. The function’s original introduction version has not been established. The formulas below use comma-separated English-locale syntax; installed regional settings or imported files may display other separators. Availability can depend on installed plugins and builds for Gnumeric functions in general.
Reproduce the example in your own worksheet
In a worksheet, enter this deliberately mixed column; leave B11 and B12 truly empty.
On a narrow screen, scroll this table sideways to see every column.
| Cell | Value | Type |
|---|---|---|
| B2 | 2 | number |
| B3 | 4 | number |
| B4 | 4 | number |
| B5 | 4 | number |
| B6 | 5 | number |
| B7 | 5 | number |
| B8 | 7 | number |
| B9 | 9 | number |
| B10 | pending | literal text |
| B11 | (no contents) | blank |
| B12 | (no contents) | blank |
This is a range of 11 cells: eight numeric, one text and two unfilled.
- Enter the values in the indicated cells in Gnumeric.
- Select a separate blank result cell outside the input range.
- Enter this formula exactly as written for the sample input:
=COUNTBLANK(B2:B12)
Expected result: 2. B11 and B12 are unfilled, while eight number cells and one text cell are populated; only the two empty cells contribute.
Input interpretation: The sample uses two truly empty cells only; ambiguous empty-string outputs are explicitly excluded from the asserted result.
Advanced application: add a useful check or calculation
After reproducing the basic result, enter:
=ROWS(B2:B12)-COUNTBLANK(B2:B12)
Expected result: 9. There are 11 cells from row 2 through row 12. Subtracting two blanks gives nine nonblank cells; check ROWS separately if the range changes.
This is a teaching example, not an assertion that the formula has been executed in this software version.
Third worked example: distinguish missing records from a complete numeric range
=COUNTBLANK(B2:B9)
Independently calculated expected result: 0. All eight measurement cells contain numbers. The two missing cells in B11:B12 should not cause this narrower, complete measurement range to be flagged. A numeric zero is still a populated cell.
Errors, edge cases and troubleshooting
- A cell that visually looks empty might contain a space or a formula. A COUNTBLANK test on ="" must be verified in installed Gnumeric, not inferred from another app.
- A wrong endpoint such as B2:B10 leaves the two intentionally empty cells outside the test.
- COUNTBLANK expects a cell range; a literal number is not an equivalent replacement for a range.
If the output differs, first confirm the exact cell contents and range boundaries; use an independent small dataset to isolate a formula issue from imported formats, hidden characters or missing values. Keep result cells outside the input ranges to avoid accidental circular references. Do not hide an error with IFERROR until you know which input is responsible.
Limits and cross-software compatibility
The official manual identifies this function as Excel compatible, but zero-length formula results and whitespace are important interoperability test cases rather than something to assume.
Gnumeric reference coverage is not a claim that every formula behaves identically in Microsoft Excel, LibreOffice Calc, Apple Numbers or other spreadsheet apps. Review the receiving application’s argument conventions, cell types and version-specific behavior before relying on workbook portability.
More related Gnumeric tutorials
Official sources and verification status
- Official Gnumeric Information function reference — COUNTBLANK (checked 2026-10-11).
- Gnumeric official function catalog (checked 2026-10-11; its headline/row totals are not treated as the canonical release count).
- Gnumeric 1.12.62 official release notes (release dated September 2026, checked 2026-10-11).
How this guide was checked
The syntax and behaviour are based on the Gnumeric references cited above. The sample calculations were independently checked; they are expected results, not outputs observed in Gnumeric. Test locale-sensitive text conversion and imported files in your own installation. View the example-check record.