The ROW function syntax has the following arguments:
- Reference Optional. The cell or range of cells for which you want the row number.
- If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears.
- If reference is a range of cells, and if ROW is entered as a vertical array, ROW returns the row numbers of reference as a vertical array.
- Reference cannot refer to multiple areas.
|2||=ROW()||Row in which the formula appears||2|
|3||=ROW(C10)||Row of the reference||10|