ROWS

ROWS(array)

Returns the number of rows in a cell range or reference.

array

The array or array formula containing the number of rows.

REMARKS

* The "array" can be a cell reference, an array constant or a named range.
* If "array" is not an array, then #VALUE! is returned.
* You can use the COLUMNS function to return the number of columns in a cell range or reference.
* You can use the ROW function to return the row number of a cell reference.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=ROWS(B1:B4) = 4	5
2	=ROWS(B3) = 1	10
3	=ROWS({1,2,3;4,5,6}) = 2	15
4	=ROWS({1,2,"some text"}) = 1	20
5	=ROWS("some text") = 1