Skip to content
Excel

ROWS function in Excel

Returns the number of rows in a reference

=ROWS(array)

ROWS syntax and parameters

One argument, one required.

  • arrayanyRequired

    An array, an array formula, or a reference to a range of cells for which you want the number of rows.

ROWS examples

Formulas you'll actually reuse.

  1. How many rows a fixed range covers:

    =ROWS(A2:A200)

    Result199

  2. The last cell of a fixed range — INDEX aimed at the final row:

    =INDEX(B2:B200, ROWS(B2:B200))

    Result13482.5

ROWS in Google Sheets

Same name — your formula ports as-is.

Try ROWS in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.