Returns the row number of a reference.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
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)תוצאה: 5
Returns the row number of cell A5.
=ROW()תוצאה: 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.