### ROW([reference])

Returns the row number of a cell reference.

 reference (Optional) The cell or range of cells for which you want the row number for.

#### Remarks

 * This function can return an array.* The "reference" cannot refer to multiple areas.* If "reference" is left blank, then the reference of the cell containing the function is used.* If "reference" is a range of cells, then the cell in the top left corner of the reference is used.* If "reference" is a range of cells referring to a vertical array and the function is entered as a vertical array formula using (Ctrl + Shift + Enter) then an array of row numbers is returned.* Rows 5 & 6 have been entered as an array formula.* For the Microsoft documentation refer to support.office.com

 A B 1 =ROW() = 1 10 2 =ROW() = 2 20 3 =ROW(C1) = 1 4 =ROW(C1:C2) = 1 5 {=ROW(C1:C2)} = 1 6 {=ROW(C1:C2)} = 2 7 =ROW(1:1) = 1 8 =ROW(4:4) = 4 9 {=ROW(INDIRECT("1:1")) } = {1} 10 {=ROW(INDIRECT("1:5")) } = {1,2,3,4,5} 11 {=ROW(INDIRECT("3:5")) } = {3,4,5}