ROWS in Apple Numbers: Count Range Rows and Exclude Table Headers

ROWS tells you how many rows a selected cell range occupies, whether those cells contain values or are empty. Apple’s version has a useful optional second headers argument: set it to 1 to exclude the table’s header and footer rows from the count, or omit it/use 0 to include them. This second argument is an important difference from Excel and Google Sheets. [A1]

=ROWS(B2:D6)

Expected: 5 rows (rows 2, 3, 4, 5, 6). This is a geometrical range count, not a count of nonblank cells. [A1, M1]

=ROWS(range, headers)

The range must identify a single range. Apple explicitly documents including/excluding headers in Numbers; do not replace this with Excel’s one-argument ROWS syntax or use 1 to mean something unrelated. [A1]

Create one Numbers table named Orders with columns A:D, rows 1:6, exactly one header row (row 1), no footer rows, and five body rows (2–6):

Enter results in a small Analysis table on the same sheet, preserving the Orders table’s six-row dimensions. When you type each function, select the indicated Orders range using the Formula Editor so Numbers qualifies the cross-table reference (for instance Orders::B2:D6) instead of using an unqualified B2:D6 in Analysis. The short reference notation below identifies the ranges in Orders; it is not intended to be pasted unqualified into Analysis. [R1]

Apple explicitly publishes a header-exclusion example for a range whose first row is a header; the results above follow that documented rule with a six-row table. [A1, M1]

Apple documents =ROWS(D) for an entire table column. In the example table it has 6 rows; if you add another row, its expected count changes with table size. Use ROWS(D) when you want the current structural height of the whole table column; use a fixed range if you want a defined analysis window. [A1, M2]

=ROWS(D)

Expected in the six-row Orders table: 6 including its header row. This is a documentation-backed application to a six-row setup, not an observed live result.

To count positions (including blank positions), multiply height by width:

=ROWS(B2:B6)*COLUMNS(B2:D6)

Expected: 5 × 3 = 15 positions. This is a cell-capacity count, not a COUNTA equivalent. It can be useful when sizing a template or checking the dimensions of a data block. [A1, A2, M3]

• ROWS(B2:B6) returns 5: how many rows the range contains.
• ROW(B6) returns 6: the coordinate of a particular cell.
• ROWS(A1:D6,1) returns 5 only because the table is explicitly set to have one header row and zero footers.

A range’s last row number and its number of rows are not interchangeable. [A1, A3]

• Result too large by one? Check whether the header is included. Omitted headers means include, not exclude. [A1]
• Result lower than expected with headers=1? Count the table’s actual header and footer rows. The option excludes both kinds; do not assume every table has exactly one header row. [A1]
• Missing data versus missing rows: a blank cell still occupies a row. ROWS counts range geometry, not nonempty records. Use an appropriate COUNT/COUNTA condition for content counts. [A1]
• Wrong table selected: a reference may silently target a different table if you copy a formula. Numbers permits qualified table references such as Orders::B2:D6 when selecting other-table data; inspect the formula editor’s selected range. [R1]
• Unsupported second parameter in another app: Microsoft Excel and Google Sheets document ROWS(range_or_array) with one required argument. Do not export the Apple header flag expecting an equivalent outside Numbers. [X1, G1]
• Exact error message not specified: the official ROWS page requires a single range; what happens with malformed/multirange input is not claimed without a Numbers test. [A1]

Apple’s ROWS(range,headers) explicitly knows about Numbers table headers and footers. Excel’s ROWS(array) and Sheets’ ROWS(range) are conceptually similar for plain contiguous ranges but do not document the Numbers-specific header flag. A workbook migrated between applications may need formula restructuring. [A1, X1, G1]

• Apple — ROWS — A1, exact signature/default/header behaviour and whole-column example; accessed 2026-10-12.
• Apple — COLUMNS — A2, matching width function; accessed 2026-10-12.
• Apple — ROW — A3, cell-row position; accessed 2026-10-12.
• Apple — Refer to cells — R1, cross-table syntax; accessed 2026-10-12.
• Microsoft — ROWS — X1, Excel one-argument syntax; accessed 2026-10-12.
• Google — ROWS — G1, Sheets one-argument syntax; 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.