=COUNTBLANK(range)

Apple’s COUNTBLANK function reference states that the function takes a single collection. Supplying two separate ranges such as COUNTBLANK(A2:A5,B2:B5) produces an error in Apple’s documented example. A comma is therefore not needed for the normal one-range formula. Apple’s general syntax reference says that locales using a comma as decimal separator use semicolons for formulas with multiple arguments; that setting does not change the required argument count for COUNTBLANK.

1. Create a table named Audit with the header Status in cell B1 and at least eight rows.
2. Enter the following into B2:B8, leaving the indicated blanks truly empty. Numeric 0 must be entered as an actual number, not an empty-looking format.
3. In D2 (outside B2:B8), enter the formula.

=COUNTBLANK(B2:B8)

Independently inspected expected result: 3, corresponding to B3, B6 and B8. There are seven cells total: three blank and four occupied. This expectation was derived from the sample data; the formula was not executed in Apple Numbers.

To see why the range matters, use a smaller selection:

=COUNTBLANK(B2:B5)

Expected result: 1 (B3 only). Including additional unused rows such as B9:B20 would raise the count even though those rows are not part of the real log; always decide which positions are required.

To measure the fraction of required rows not yet filled in, use:

=COUNTBLANK(B2:B8)/(COUNTA(B2:B8)+COUNTBLANK(B2:B8))

Independently calculated expected numerical value: 3/7 ≈ 0.4285714, which displays as approximately 42.86% when formatted as a percentage with two decimals. COUNTA(B2:B8) is expected to be 4 in this dataset. This ratio recomputes if the contents of cells in the selected seven positions change. It does not automatically enlarge its reference if later rows are added.

If all positions are genuinely blank, the denominator still includes them; if the selected range is invalid or the calculation produces an error, use Numbers’ formula error display for diagnosis. Avoid a denominator of zero when developing more general formulas with dynamically empty collections.

When one range is not enough

Apple documents that two separate COUNTBLANK ranges in one call are an error. If you need two independent groups, use two complete calls:

=COUNTBLANK(B2:B5)+COUNTBLANK(B6:B8)

Expected result: 1 + 2 = 3. This example preserves the function’s one-range argument contract; it is an independently reasoned expression built from documented syntax, not a native test.

• Two input ranges in one COUNTBLANK call: Apple documents an error for this form. Add separate calls or count one contiguous range instead.
• Numeric zero, Boolean FALSE, or placeholder text: these are not physically blank cells and should not be used as surrogates for missing values.
• A cell that visually looks blank: a space, hidden content, or a formula returning an empty-looking string can complicate interpretation. Apple’s COUNTBLANK article describes empty cells but does not specify every formula-"" edge case; verify this one directly in the target Numbers installation rather than applying Excel’s documented rule automatically.
• Unexpected blank rows: avoid a range that includes intentionally unused future entries or the blank result area.
• Wrong table: a Numbers sheet may contain multiple named tables. The formula B2:B8 here refers to the current table; if the result cell is elsewhere, select Audit in the formula editor to insert a table-qualified reference.
• Circular references: do not put your COUNTBLANK result within the cells that you count.

When the count is unexpectedly high, confirm the selected range does not include unused future rows. When unexpectedly low, inspect apparently empty cells for spaces, invisible content, and formula results. Test the ranges in smaller sections, such as B2:B5 and B6:B8, and compare to the hand count. If the formula throws an error, check for an extra comma, multiple range arguments, invalid references or misspelled function names; follow the exact one-argument syntax.

Verified reference: Apple Formulas and Functions Help version path 15.4, accessed 2026-10-11. Apple exposes a unified function-help catalogue, but this page has not established COUNTBLANK’s initial introduction or identical support in every Numbers version on Mac, iPhone, iPad, or iCloud.com. The examples are written for the English documented syntax and a table named Audit; use the formula editor to select named tables instead of copying Excel’s Sheet1!B2:B8 notation. For manually typed functions with multiple arguments elsewhere, Apple documents semicolons when the decimal separator is a comma.

Excel also has a one-range COUNTBLANK formula; Microsoft’s reference explicitly says Excel counts cells with formulas returning an empty string and excludes zero values. Do not infer that Numbers has the same empty-string rule from Microsoft’s Excel documentation; a cross-app migration needs its own check. COUNTBLANK is a common spreadsheet concept, but sheet/table reference syntax and edge cases differ across Excel, Google Sheets and LibreOffice Calc.

• COUNTIF — count rows matching a given condition.
• COUNTIFS — count with several conditions.
• SUMIFS — add numeric amounts under several conditions.

Related guides: COUNTA and COUNT.

• Apple Numbers — function documentation
• Apple — Functions overview
• Apple — COUNTA

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

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.