Apple iWork '09 - Manual (Page 221)

Chapter 9 Reference Functions 221
ROW
The ROW function returns the row number of the row containing a specified cell.
ROW(cell)
 cell: An optional reference to a single table cell. cell is a reference value to a single
cell that can contain any value, or be empty. If cell is omitted, as in =ROW(), the
function returns the row number of the cell that contains the formula.
Examples
=ROW(B7) returns 7, the number of row 7.
=ROW() returns the absolute row number of the cell containing the function.
Related Topics
For related functions and additional information, see:
“COLUMN” on page 210
“INDEX” on page 214
“Listing of Reference Functions” on page 206
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
ROWS
The ROWS function returns the number of rows included in a specified range of cells.
ROWS(range)
 range: A range of cells. range is a reference to a single range of cells, which may
contain values of any type.
Usage Notes
If you select an entire table column for  range, ROWS returns the total number of
rows in the column, which changes when you resize the table.
Examples
=ROWS(A11:D20) returns 10, the number of rows from 11 through 20.
=ROWS(D:D) returns the total number of rows in column D.