ROWS(array)

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

arrayThe 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.
* For the Microsoft documentation refer to support.office.com

 AB
1=ROWS(B1:B4) = 45
2=ROWS(B3) = 110
3=ROWS({1,2,3;4,5,6}) = 215
4=ROWS({1,2,"some text"}) = 120
5=ROWS("some text") = 1 

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top