Apple numbers User Manual

    Dictionary of Functions 

 

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.

  

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.
  

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.

ROW(B7) returns 7, the number of row 7.

ROW() returns the absolute row number of the cell containing the function.

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.