Manuals/calci/ROWS

Revision as of 20:43, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ROWS'''</font></font></font><font color="#484848...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 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