=COUNTA(value, value…)

The spelling, argument order, and allowance for multiple values are documented in Apple’s COUNTA reference. Apple’s official example explicitly counts nonempty numbers, words, TRUE and FALSE values. For Numbers in English, the reference shows commas between separate arguments; if the decimal separator is a comma, Apple directs you to use semicolons between arguments when typing manually (functions overview). No separator is needed inside a single range such as A2:A7.

1. Create a Numbers table named Survey with Response in A1. Make sure there are at least seven rows in the table.
2. Enter the exact values below; leave A4 truly empty, without a space, apostrophe, or formula. Enter 0 as a number and FALSE as the Boolean value, not as quoted text.
3. In D2 of the same table (a cell outside the counted range), enter the formula.

=COUNTA(A2:A7)

Independently counted expected result: 5. All cells except A4 have a value. In particular, 0 and FALSE are not empty; the text TBD also counts, although it may not represent a useful answer. This is an arithmetic/data-inspection expectation, not a result observed inside Apple Numbers.

For a second independently checked expression:

=COUNTA(A2:A7,"Extra")

Expected result: 6: the five nonempty cells plus the supplied additional nonempty text argument. The documentation permits extra direct values; it does not imply that "Extra" was written to another cell.

For six required response slots (A2:A7), calculate a populated-cell rate:

=COUNTA(A2:A7)/6

Expected numerical value: 5/6 ≈ 0.8333333; format the result cell as a percentage to display about 83.33% (rounding and display can depend on cell format). Another more adaptable approach uses the range’s own populated and blank counts:

=COUNTA(A2:A7)/(COUNTA(A2:A7)+COUNTBLANK(A2:A7))

Expected numerical value: again 5/6. These expressions describe cell occupancy, not validated survey completion. A TBD placeholder, 0, or FALSE value counts as occupied. If the total number of positions might be zero, do not divide without handling that case.

Numbers table-reference details

The example formulas are entered in the same table as A2:A7. If the formula is in a separate table, select the range in the formula editor so Numbers includes the source table’s name; cross-table references can resemble Survey::A2:A7 rather than Excel’s Sheet1!A2:A7. Use the actual name Numbers inserts. Do not count a summary cell containing its own COUNTA formula or create a circular reference.

• Looks blank but counts: a cell with only a visible space is not the same as an empty cell. Clear it if you intend it to be blank.
• Placeholders count: TBD, ?, and other response labels all contribute, so this is not a validity test.
• Boolean values and numeric zero: both are contents; Apple’s own example counts Boolean values.
• Formula-produced empty-looking text: Apple’s COUNTA page does not explicitly resolve every case involving formulas returning ""; check this behaviour in the target installed Numbers version before basing a completeness audit on it. Do not infer an Excel-specific rule.
• Wrong rows: including A1 would count the header; selecting too few rows understates the tally. Avoid counting a whole column with an unintended summary or header unless you deliberately want that.
• Errors in other calculations: COUNTA measures occupancy. It does not make a broken numeric calculation valid, and a spreadsheet error elsewhere needs its own diagnosis.

If you expected 4 but received 5, inspect hidden spaces or placeholder entries. If you expected 5 but received 4, check for an actually empty response, incorrect range or reference to a similarly named table. To narrow the discrepancy, try =COUNTA(A2:A4) and =COUNTA(A5:A7) separately (expected 2 and 3 in this sample), then add the two counts. Use the formula editor’s highlighted range before copying a formula between tables.

The syntax and behaviour cited here come from Apple’s Formulas and Functions Help documentation path 15.4, checked 2026-10-11. Apple’s help entry point identifies the function-help ecosystem used with Numbers on Mac and iPhone/iPad and Apple’s online apps; the function reference alone does not prove a first-supported Numbers release or uniform historical macOS/iOS/iPadOS/iCloud.com behaviour. No device-specific runtime validation was performed. Verify older installed versions before relying on the feature.

Excel also has COUNTA and differentiates it from COUNT (numbers) and COUNTBLANK (empty cells) in Microsoft’s counting overview. The general purpose transfers to Excel, Google Sheets and LibreOffice Calc, but table-reference notation, localization, and interpretations of empty-looking formula results must be tested in the destination app. An Excel worksheet reference such as Sheet1!A2:A7 is not Numbers’ equivalent table reference syntax.

• COUNTIF counts entries matching one criterion rather than all occupied cells.
• COUNTIFS counts rows matching multiple conditions.
• SUMIFS sums matching numeric values rather than counting occupied cells.

• Apple Numbers — function documentation
• functions overview
• help entry point

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.