Manuals/calci/ROWS
ROWS(arr)
where arr is an array,
It gives the number of rows in a reference or [javascript:AppendPopup(this,'xldefArray_1') array][javascript:AppendPopup(this,'xldefArray_1') .]
ROWS
Let's see an example
=ROWS(C1R1:C3R5) is 5
Syntax
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 2 | |||
Row2 | 5 | |||
Row3 | ||||
Row4 | ||||
Row5 | 10027 | |||
Row6 |