Skip to content
Google Sheets

ROW function in Google Sheets

Returns the row number of a specified cell.

=ROW([cell_reference])

ROW syntax and parameters

One argument, zero required.

  • cell_referencerangeOptional

    [ 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.

ROW examples

Formulas you'll actually reuse.

  1. A row number that starts at 1 under the header (fill down from row 2):

    =ROW() - 1

    Result1

  2. Sum every other row (even sheet rows) without a helper column:

    =SUMPRODUCT((MOD(ROW(B2:B200), 2) = 0) * B2:B200)

    Result74100

ROW in Excel

Same name — your formula ports as-is.

Try ROW in the playground

Edit the example — nothing to install.

Preloaded with the ROW formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.