The ‘ROWS’ function in Excel will return the number of rows between a specified cell range. For example, there are two rows between row 3 and row 5 and thus =ROWS(B4:D5) would return an output of 2.
The ROWS function can be particularly useful when using functions which require a row argument on large sets of data where it is not easy to manually count the number of rows in an array.
To identify the specific row number of an individual cell, the ROW function is more appropriate to use.
array – input cell range (i.e. the cell the range you wish to know how many rows there are in between)
The ROWS function will return the number of rows between a specified cell range.