ROW in Apple Numbers: Find Row Numbers and Number Table Records

• Introduced: Documented in Apple’s Formulas and Functions Help 15.4; the original introduction release is not established.
• Availability: Currently documented for Numbers in that help version; it is not a final supported-version endpoint.
• Scope: Shared iWork function help. Availability in individual clients and older releases is not established by this check.
• Checked: October 14, 2026, against the official ROW reference. Documentation check; not a new native test.

ROW reports the row number of a cell in a Numbers table. For example, =ROW(B7) gives 7. If you leave its optional argument blank, =ROW() returns the row number of the cell containing that formula. It is a position lookup—not a count of how many records exist. [A1]

=ROW(B7)

Expected: 7 (also stated in Apple’s official example). [A1]

=ROW(reference)

Apple writes the argument without brackets in its signature but explicitly calls it optional in the description; both ROW(B7) and ROW() are documented. Avoid claiming that a multi-cell reference will spill an array in Numbers: Apple lists range references but does not establish that Excel-style array behaviour. Use a single-cell reference for predictable scalar examples. [A1]

Create a 7-row, 5-column table named Inventory with row 1 as a header. Enter this input data:

Test formulas in unused cells of this same Inventory table:

The value inside B4 or C3 is irrelevant to their position. =ROW() depends on where you enter it, so do not treat a screenshot from another row as a fixed answer. [A1, M1]

If row 1 is the only header row, place this in C2:

=ROW()-1

Expected in C2: 1. Copy/fill downward to C3 and C4; expected IDs become 2 and 3. This is row-position numbering, not a permanent identifier: inserting, deleting, moving or changing your header-row layout can change the resulting numbers. For stable IDs, enter them as fixed values instead of deriving identity from a position. [A1, M2]

Create another sheet called Sheet 2 containing a table Table 1, with at least five rows. Then, in a separate table, use the cross-sheet reference selected by the Formula Editor:

=ROW(Sheet 2::Table 1::C5)

Expected: 5, assuming the reference resolves to that table’s C5. Apple documents the Sheet 2::Table 1::C5 qualification format. Text entry of table names with spaces is less reliable than selecting the reference in the editor. This exact composed formula is reasoned from documentation, not natively executed. [R1, M3]

ROW(B4) identifies which row B4 is on: 4. ROWS(B2:B4) identifies how many rows are in that range: 3. Use ROWS to calculate range size and ROW for position. [A1, A2]

• If ROW() displays an unexpected number, look at the formula’s own table row, not the item number or sheet position you intended. [A1]
• If a cross-table reference is not recognized, check exact sheet/table names and select the cell through the formula editor. Numbers can qualify other-table references with ::. [R1]
• Do not type "B7" in quotation marks: that is text, not a cell reference. Choose B7 through the reference picker. This guide does not claim a specific Numbers error code for a wrong argument type. [A1, R1]
• ROW() does not report the visible number of filtered, nonempty, or sorted records. It reports a table row coordinate. For counting a range, use ROWS instead. [A1, A2]
• Apple has not documented in this individual help page how a multi-cell ROW reference behaves in every array context. Avoid copying Excel’s dynamic-array behaviour without a Numbers test. [A1, X1]

Excel and Google Sheets also document the ROW function with an optional reference and an implicit current-cell default. Excel documents a separate array-return case for a range and Sheets describes a first-row rule in a non-array context; Apple’s ROW page does not explicitly make those promises. Compare those environments separately when importing workbooks. [X1, G1, A1]

• Apple — ROW — A1, signature, optional reference and documented B7 example; accessed 2026-10-12.
• Apple — ROWS — A2, counting range height; accessed 2026-10-12.
• Apple — References in formulas — R1, table/sheet qualifier; accessed 2026-10-12.
• Microsoft — ROW — X1, Excel comparison only; accessed 2026-10-12.
• Google — ROW — G1, Sheets comparison only; accessed 2026-10-12.

This guide was checked against Apple’s English Formulas and Functions Help on 12 October 2026. The official function page is a Numbers Help 15.4 URL unless noted otherwise. Apple’s current Mac user guide identifies Numbers 15.4; the function’s first-ever release and behaviour in older Numbers versions have not been independently established. Apple also describes the Functions Browser in Numbers on Mac, iPhone, iPad, and iCloud.com; do not assume all historical versions are identical. [V1]

Numbers formulas operate inside tables, not against an undifferentiated worksheet grid. For the examples, create one table with the stated row/column dimensions; a plain reference such as B7 points into the formula’s table. To refer to a different table, Apple’s syntax uses Table 2::B7; for another sheet, it may be Sheet 2::Table 1::C5. In the Formula Editor, selecting the source cell is safer than typing a cross-table name manually. References inside a range use a colon, e.g. B2:D6. [R1]

The copyable formulas use English-language function names and comma separators as displayed in the cited English Apple help. Apple’s language/region settings affect number, currency, and date formatting; the exact argument separator and localized function spelling for every locale were not natively tested. If your Numbers Formula Editor presents different separators, use what it shows rather than copying punctuation blindly. For these reference-and-Boolean functions, changing the decimal locale does not change the intended row/column count or TRUE/FALSE logic. [L1]

Validation distinction: Numbers was not run. Outputs labelled expected below are either explicitly illustrated in Apple’s documentation or independently calculated from the example’s defined table coordinates/logic. No screenshot or application-observed result is claimed.

Official syntax was checked against Apple documentation. Worked values are independently calculated expectations, not native application results. Native Apple Numbers execution, screenshots, historical-version behavior and exact error messages were not tested.

Common source and calculation notes

[V1] Apple Numbers version history; [L1] Apple function syntax and locale separators. Checked 13 October 2026. M1–M3 identify the independent coordinate/count calculations explained beside the examples, not native application measurements.