Excel ROWS Function

Using the Excel ROWS Function


The Excel ROWS function is used to return the number of rows in a reference range or array. For example, ROWS (A1:A10) would return 10 since the range A1:A10 contains ten rows.


=ROWS (array)

Syntax Breakdown

Required. The argument can be an array, array formula, or a reference to a range of cells for which you want to find the number of rows.

Usage Notes

ROWS returns the count of rows in a given range.

Use the ROW function to return the row number of a specific cell.