Google Sheets-funktion

ROW

Returns the row number of a reference.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

referencevalfrittThe cell or range of cells for which you want the row number.

Exempel

=ROW(A5)

Resultat: 5

Returns the row number of cell A5.

=ROW()

Resultat: 1

Returns the row number of the cell containing the formula (assuming it is in row 1).

Vanliga frågor

What happens if I provide a range to the ROW function?

If you provide a range, ROW returns the row number of the first cell in that range.

Relaterade funktioner

ROWS COLUMN COLUMNS ADDRESS