How do I apply a row to a formula in Google Sheets?

ROW

Returns the row number of a specified cell.

Sample Usage

ROW(A9)

Syntax

ROW([cell_reference])

cell_reference - [ OPTIONAL - The cell in which the formula is entered by default ] - The cell whose row number will be returned.

• if cell_reference is a range more than one cell wide and the formula is not used as an array formula, only the numeric value of the first row in cell_reference is returned.

See Also

ROWS: Returns the number of rows in a specified array or range.

COLUMNS: Returns the number of columns in a specified array or range.

COLUMN: Returns the column number of a specified cell, with `A=1`.

Examples

Returns the row number of a cell reference.

Need more help?

Try these next steps:                  Ask the Help Community Get answers from community experts

Video liên quan