Returns the row number of a reference.
Syntax
ROW([reference])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.
| Formula | Description | Result |
| =ROW() | Row in which the formula appears | 2 |
| =ROW(C10) | Row of the reference | 10 |