Returns the number of rows in a reference or array.
Syntax
ROWS(array)
Array is an array, an array formula, or a reference to a range of cells for which you want the number of rows.
Examples
ROWS(A1:C4) equals 4
ROWS(A1:C4)
ROWS({1,2,3;4,5,6}) equals 2
ROWS({1,2,3;4,5,6})