ROWS

Using the Excel ROWS Function

Summary

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.

Syntax

=ROWS (array)

Syntax Breakdown

Array
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.