Google Sheets-functie

ROW

Returns the row number of a reference.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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.

Argumenten

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

Voorbeelden

=ROW(A5)

Resultaat: 5

Returns the row number of cell A5.

=ROW()

Resultaat: 1

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

Veelgestelde vragen

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.

Gerelateerde functies

ROWS COLUMN COLUMNS ADDRESS