Excel Function : ROWS
Category
Lookup and reference
Description
Returns the number of rows in a reference
Microsoft Excel Reference Page
https://support.office.com/en-us/article/ROWS-function-b592593e-3fc2-47f2-bec1-bda493811597
Syntax and Description of the ROWS Excel Function
The syntax for the ROWS function in Microsoft Excel is: =ROWS(array) Where "array" is the range of cells or array that you want to count the number of rows in.
About ROWS Excel Function
ROWS(array) returns the number of rows in an array.