Skip to content
Google Sheets

ROWS function in Google Sheets

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

=ROWS(column)

ROWS syntax and parameters

One argument, one required.

  • columnrangeRequired

    The data column whose row count will be returned.

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 Excel

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