ROWS function
Summary
Returns the number of rows in a reference
Syntax
ROWS(array)
The ROWS function syntax has the following argument:
• Array Required. An array, an array formula, or a reference to a range of cells for which you want the number of rows.
• Array Required. An array, an array formula, or a reference to a range of cells for which you want the number of rows.
Example
=ROWS(C1:E4)
=ROWS({1,2,3;4,5,6})
=ROWS({1,2,3;4,5,6})