Excel ROWS function

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.

Syntax

=COLUMNS(array)

Arguments

array – input cell range (i.e. the cell the range you wish to know how many rows there are in between)

Function category

Information

Returns

The ROWS function will return the number of rows between a specified cell range.

Download Excel File

 Example of ROWS formula
error

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.