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.