Returns the row number of a reference.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
ROW([reference])The ROW function returns the row number of a specified cell reference. If the reference argument is omitted, the function returns the row number of the cell where the formula is entered.
=ROW(A5)Ergebnis: 5
Returns the row number of cell A5.
=ROW()Ergebnis: 1
Returns the row number of the cell containing the formula (assuming it is in row 1).
If you provide a range, ROW returns the row number of the first cell in that range.