MS Excel: Rows Function

In Excel, the Rows function returns the number of rows in a cell reference.

The syntax for the Rows function is:

Rows ( reference )

reference is a reference to a range of cells or an array.

Applies To:

Let's take a look at an example:

=Rows(B4) would return 1

=Rows(A4:B6) would return 3

=Rows({1,2;3,4}) would return 2

=Rows({1,2,3,4;5,6,7,8}) would return 2

You can also defined a named range called suppliers that refers to Sheet1!$A$1:$C$8.

Then using the Rows function, you could refer to this named range as follows:

=Rows(suppliers) would return 8