| Line 1: |
Line 1: |
| − | <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"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''arr'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
| + | == ROWS(array) == |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where arr'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is an array,</font></font></font>
| + | *where <math>array</math> is an array or reference |
| | | | |
| − | </div>
| + | ROWS() displays the number of rows in an array or reference. |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">It gives the number of rows in a reference or </font></font></font>[javascript:AppendPopup(this,'xldefArray_1') <font color="#000000"><font face="Arial, sans-serif"><font size="2">array</font></font></font>][javascript:AppendPopup(this,'xldefArray_1') <font color="#484848"><font face="Arial, sans-serif"><font size="2">.</font></font></font>]</div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| | | | |
| − | ROWS
| + | == Description == |
| | | | |
| − | </div></div>
| + | ROWS(array) |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example</font></font></font>
| + | For Example, |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ROWS(C1R1:C3R5) is 5</nowiki></font></font></font>
| + | ROWS(B4) ''returns 1''. |
| | | | |
| − | </div> | + | *<math>array</math> can be a cell, range of cells or an array. |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
| |
| − | ----
| |
| − | <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | {| id="TABLE2" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | Column2
| |
| − | | Column3
| |
| − | | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f " | 2
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="sshl_f" | 5
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class=" sshl_f " |
| |
| − | | class=" " |
| |
| − | | class=" SelectTD SelectTD" |
| |
| − | <div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " | 10027
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" sshl_f sshl_f " |
| |
| − | | class=" " |
| |
| − | |}
| |
| | | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| + | == Examples == |
| − | ----
| |