Skip to content
Excel

ROW function in Excel

Returns the row number of a reference

=ROW([reference])

ROW syntax and parameters

One argument, zero required.

  • referencerangeOptional

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 Google Sheets

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 Excel gets this done.