Returns the number of rows in the specified range or array.
Syntax
 Copy Code
|
|---|
ROWS( ReferenceOrArray r ) → Integer |
Parameters
- r
- Required. A reference to a range of cells or an array for which to return the number of rows.
Example
| Formula
Copy Code
|
|---|
=ROWS(A1:E4) |