Using the Excel ROWS Function
SummaryThe 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.
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 NotesROWS returns the count of rows in a given range.
Use the ROW function to return the row number of a specific cell.