COUNTBLANK Function in ONLYOFFICE Spreadsheet Editor: Examples and Syntax

=COUNTBLANK(range)

Put an equals sign before the function name, keep the range inside parentheses, and use a genuine cell range, not a text description of the range. The official ONLYOFFICE function reference defines the operation as counting empty cells. The function-entry guide describes typing =, autocomplete, the Function Arguments window, and using Shift+F3.

Documentation correction: The current index of functions shows the label COUNBLANK, but its link opens the heading and syntax COUNTBLANK. It is a documentation-index typo; no evidence supports a separate COUNBLANK function, alias or second tutorial.

Create this table, leaving the three empty owner cells genuinely blank (do not type the word blank, a space, or an equals sign):

1. Select an unused result cell, such as D2.

2. Enter:

   =COUNTBLANK(B2:B7)
   

3. Expected result: 3. Cells B3, B5 and B7 contain no input. B2, B4 and B6 contain owner names. This answer is independently counted from the visible sample, not observed in the native application.

4. Fill B3 with a real owner’s name and recalculate. Expected after that edit: 2.

5. Avoid changing the endpoint to B2:B8 unless row 8 belongs to the dataset: that would count an additional unused blank cell.

To calculate the fraction of assignments missing from the six ticket rows, use ROWS (also separately documented by ONLYOFFICE):

=COUNTBLANK(B2:B7)/ROWS(B2:B7)

Expected number: 0.5; as a percentage-formatted cell, 50%. The count is 3, and the row count is 6; 3/6=0.5. The matching completion rate can be written as:

=1-COUNTBLANK(B2:B7)/ROWS(B2:B7)

Expected: 0.5 (50% assigned). If you assign one more owner, expected missing share becomes 2/6, or about 33.33%, and expected assigned share becomes 4/6, or about 66.67%. Be careful: a range containing extra unused rows would make these percentages misleading even though the formula is syntactically valid.

For a second basic sanity check, type the number 0 in E2, leave E3 genuinely empty, then use =COUNTBLANK(E2:E3); expected 1. A numeric zero is a populated value, not an empty input. The exact behavior of a formula returning an empty string is a separate issue below.

• Truly empty vs. formula-generated empty-looking cells: Microsoft’s Excel COUNTBLANK documentation explicitly says it counts formulas evaluating to empty text (""). The currently checked ONLYOFFICE COUNTBLANK help does not specify that edge case. Do not assert an identical outcome: enter ="" in a separate test cell and observe the behavior in the precise ONLYOFFICE version you publish for. This native test is pending, and no expected ONLYOFFICE result is invented.
• Whitespace isn’t visually obvious: If your result seems low, check for a typed space or imported text in apparently empty cells. Remove unwanted characters and test again; do not infer emptiness from screen appearance alone.
• Zero is not blank in the illustrative data: Use the small E2:E3 test above to distinguish a zero-value entry from a genuinely empty cell. Confirm this expected output in ONLYOFFICE during review.
• Unexpectedly large blank count: Recheck the selection. B2:B1000 spans hundreds more cells than the six-row ticket range.
• No result/error on entry: Type the function spelling COUNTBLANK, not the catalogue typo COUNBLANK, and select the range with the function editor. Only one range argument is documented; do not add an invented condition argument.
• Hidden/filtered rows or merged cells: The short ONLYOFFICE reference does not spell out every such interaction. Native tests should establish the desired workbook behavior instead of importing a rule from Excel by assumption.

COUNTBLANK(B2:B7) asks how many empty cells? By contrast, COUNTIF applies a chosen criterion to a range and COUNTIFS combines criteria. Both have existing owner-source guides at COUNTIF and COUNTIFS. ISBLANK checks a single value and returns a logical result, per its ONLYOFFICE reference; it is not the same operation as counting blanks over an area.

Excel and ONLYOFFICE document the same COUNTBLANK(range) syntax. Excel’s explicit ="" rule is a difference in currently documented detail, not proof of a different ONLYOFFICE implementation. Locale and runtime conversion edge cases are still untested. If a workbook comes from Excel, verify a few intentionally blank, formula-empty and zero-value cells in the target editor before trusting automated completeness reports.

COUNTBLANK appears in the current unversioned ONLYOFFICE Docs Spreadsheet Editor catalogue, and the canonical function page is accessible as of 2026-10-11 UTC. Those pages do not identify a first supported release or certify every web-hosted Docs build, Desktop Editors build, mobile application, edition or historical version. The Docs changelog and Desktop Editors changelog are distinct: do not extrapolate an earliest version from the current index. Desktop/mobile coverage and any locale-specific entry quirks still require separate checks.

• ONLYOFFICE Spreadsheet Editor — function documentation
• function-entry guide
• ONLYOFFICE reference
• Docs changelog
• Desktop Editors changelog
• ONLYOFFICE ROWS(range) argument documented as ROWS(array)

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.