ROWS Function Explained
The ROWS Function in Microsoft Excel returns the number of rows in a given array. It takes a single argument, which is an array of cells or a range of cells, and returns the number of rows in that array.
ROWS Function Syntax
ROWS(array)
- array: The array of cells or range of cells for which you want to count the number of rows.