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.


=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