ROWS Function

The ROWS () is a lookup and reference function which takes the argument "array" and returns the number of rows in a cell reference or array.

Formula:


=ROWS (array)
In the above syntax, the argument "array" denotes an array or a reference to the range of cells for which you want the number of rows.

Video Tutorial:


Let us see how the ROWS () returns the number of rows, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question