If a reference is to a cell, the ROW function returns the row number of the cell.
is a cell, an area, or the name of an area.
If you do not indicate a reference, the row number of the cell that contains the formula is found. The reference to the current cell is automatically set.
because the reference refers to the third row in the table.
returns the single-column array (5,6,7,8
) because the reference specified contains rows 5 through 8.
both return 1
if the formula was entered in row 3.
Parent topic: Spreadsheet functions