Apple Numbers '08 - Manual (Page 270)

270 Chapter 12 Dictionary of Functions
ROW
The ROW function returns the row number of the specified cell.
ROW([cell])
 cell: Optional; a reference to a single cell. If not provided, ROW returns the row of the
cell containing the function.
ROWS
The ROWS function counts how many rows are in the specified range of cells.
ROWS(cell-range)
 cell-range: A reference to a range of cells.
Notes
If you select an entire column for cell-range, Numbers returns the total number of cells
in the column, which changes when you resize the table.
SEARCH
The SEARCH function finds the starting position of one string within another, ignoring
case but allowing wildcards.
SEARCH(search-text, where-to-look, [start])
 search-text: The string you want to find. You can include an asterisk (*) to match any
number of characters or a question mark (?) to match any single character.
 where-to-look: The text in which you want to look for the string.
 start: Optional; a number indicating the position in the text where you want to start
the search. If omitted, the search starts at the beginning of the text.
Examples
ROW(B7) returns 7, the number of row 7.
ROW() returns the absolute row number of the cell containing the function.
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.