COUNT Function in Apple Numbers: Syntax, Examples, and Troubleshooting

Apple documents COUNT(value, value…). value is one required value or collection (for example a cell range); value… allows optional additional values or collections. Apple specifically describes COUNT as counting arguments containing numbers, numeric expressions or dates. The official examples demonstrate that text cells and boolean TRUE/FALSE cells do not count. Do not confuse COUNT with COUNTA, which counts nonempty cells.

=COUNT(value, value…)

Examples: =COUNT(4,7,9) has expected answer 3; =COUNT(4,7,"pending") has expected answer 2 from Apple’s described numeric/text distinction. =COUNT(A2:A8) counts no numeric cells in our string Order ID column (expected 0).

Source: Apple COUNT.

1. Create a new spreadsheet and add or rename a table Orders. Make the first row its header row.
2. Add three columns with the headers Order ID, Amount (CAD), and Region in A1, B1 and C1.
3. Enter the following seven records in A2:C8. Type pending as plain text in B7. Leave B8 genuinely empty (do not type the words “empty” or 0).
4. Set B2:B6 to Number or Currency so these five entries are numeric cells. Place every result formula in a separate result cell, for example E2, in the same Orders table.

Why this matters: B2:B6 contains exactly five numbers (120, 75, 90, 115, 35). B7 is text and B8 is blank; these are deliberately different cases. A2:A8 contains seven nonempty text order IDs. The worked answers below are independent calculations for this particular table, not screenshots or claims of a Numbers execution.

1. Select a free result cell such as E2 inside Orders.
2. Enter:

=COUNT(B2:B8)

Expected result: 5. B2–B6 contain five numbers. B7 contains pending as text, and B8 is truly empty; neither counts. The number of records is seven, so do not label COUNT as a row count when some values are missing.

=COUNT(B2:B8,200)
=COUNT(A2:A8)

Expected results: 6 and 0, respectively. In the first formula, five numeric Amount cells plus one numeric literal (200) are counted; the literal is an extra argument, not an additional order row. The second sees seven text IDs, which are not numbers.

Use COUNTA to count all nonempty Order ID cells, then compare with COUNT of the Amounts. Apple’s COUNTA documentation confirms it counts nonempty text cells.

=COUNT(B2:B8)/COUNTA(A2:A8)

Expected underlying numeric result: 5/7 ≈ 0.7142857143, or 71.43% when the result cell is formatted to two decimal percent places. The formula measures the share of orders with a numeric Amount, not the share of successfully paid orders. It assumes each nonempty ID represents one order. If the denominator is empty, this division needs an explicit guard; the exact Numbers error presentation was not tested.

Useful cross-check:

=COUNTA(B2:B8)

Expected result: 6 because B2–B7 are nonempty, but B8 is empty. The difference between COUNTA(B2:B8)=6 and COUNT(B2:B8)=5 is the one text entry in B7.

Source: Apple COUNTA.

• COUNT is lower than the number of rows: This is expected with blank, text, or boolean input cells. Our example deliberately contains five numeric values across seven rows.
• Imported numbers stored as text: A cell displaying 120 may have a text value. Correct the type before depending on numeric COUNT; displaying a currency symbol is not enough proof.
• Dates versus text dates: Apple includes genuine date values in COUNT, but a string that merely looks like a date may remain text. Check cell type. Do not infer that duration handling matches date handling without a native test; Apple’s COUNT page does not explicitly certify it.
• Need all nonempty entries: Use COUNTA(range) instead of COUNT. Need only empty entries? Use COUNTBLANK. Need category matches? Use COUNTIF/COUNTIFS.
• Want order completeness: Use a trustworthy identifier range as denominator (here A2:A8) and audit missing/duplicate identifiers separately. A naive ratio can be misleading if identifier cells are blank.
• No output or a formula error: Check cell references, whether a referenced table exists and the locale separator. No particular Numbers error message was observed during this batch.

Apple documentation note: An English sentence in the currently retrieved COUNT page’s A5:D5 example describes a count of 2 as being because two cells are empty; its own table actually has two numeric cells and two empty cells. The formula’s result of 2 is consistent with counting the numeric cells, not the empty ones. This guide therefore uses an independently explicit dataset and does not repeat the ambiguous explanation.

Apple’s English syntax uses commas between arguments. If your decimal separator is a comma, Apple’s Functions overview instructs you to type semicolons between function arguments instead. The one-range formulas here need no argument separator. To reference a different table, use Numbers’ explicit Orders::B2:B8-style reference when needed; from another sheet, Numbers can use Sheet Name::Orders::B2:B8. Select cells in the formula editor if a table or sheet name needs quoting or the name is ambiguous. Excel-style Orders!B2:B8 is not the equivalent Numbers syntax.

Official evidence: Functions overview and Refer to cells in formulas.

The function name and basic purpose also exist in Microsoft Excel, Google Sheets and LibreOffice Calc, but do not paste a cross-table reference unchanged: Numbers uses table-qualified forms such as Orders::B2:B8, whereas Excel and Sheets typically qualify worksheet references differently. Argument separator requirements depend on the application and locale. Numbers also documents date/time and duration input rules; do not presume that another application accepts or displays those mixed types in precisely the same way. Check the destination application’s behaviour with representative data before migrating a workbook.

• COUNTIF — count matching order statuses
• COUNTIFS — count records passing multiple tests
• SUMIFS — add amounts subject to multiple criteria
• Related guides: MIN, MAX, and COUNT.

• Apple COUNT function reference — numeric expressions and dates count; text/booleans are excluded in official examples; literal plus range usage.
• Apple Functions overview — syntax typography, required/optional arguments, regional separators.
• Apple cell and table references — local ranges and Table::Cell/Sheet::Table::Cell forms.
• Apple Formulas and Functions Help — documented in-app Functions Browser context.
• Apple COUNTA — counts nonempty strings and numeric values; used for completion ratio.
• Apple COUNTIF

• Apple Numbers — function documentation
• Apple COUNTA
• Functions overview
• Refer to cells in formulas
• Apple Formulas and Functions Help
• Apple COUNTIF

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.