Search
Clear search
Close search
Google apps
Main menu

ROWS

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

Sample Usage

ROWS(A9:A62)

ROWS({1;2;3;4;5})

Syntax

ROWS(range)

  • range - The range whose row count will be returned

See Also

ROW: Returns the row number of a specified cell.

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 number of rows in a reference or array.

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?
false