Difference between revisions of "Manuals/calci/ROWS"

From ZCubes Wiki
Jump to navigation Jump to search
(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...")
 
 
(7 intermediate revisions by 3 users not shown)
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>
+
<div style="font-size:30px">'''ROWS (Array) '''</div><br/>
 +
*where <math>Array</math> is an array or reference
 +
**ROWS() displays the number of rows in an array or reference.
  
−
<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>
+
== Description ==
  
−
</div>
+
ROWS()
−
----
+
*For Example,ROWS(B4) ''returns 1''.
−
<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>
+
*<math>Array</math> can be a cell, range of cells or an array.
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
ROWS
 
  
−
</div></div>
+
== Examples ==
−
----
 
−
<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>
 
−
 
−
<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ROWS(C1R1:C3R5) is 5</nowiki></font></font></font>
 
−
 
−
</div>
 
−
----
 
−
<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">
 
<div id="4SpaceContent" class="zcontent" align="left">
  
Line 32: Line 17:
 
|- class="even"
 
|- class="even"
 
| class=" " |
 
| class=" " |
−
| Column1
+
| ColumnA
−
| Column2
+
| ColumnB
−
| Column3
+
| ColumnC
−
| Column4
+
| ColumnD
 
|- class="odd"
 
|- class="odd"
 
| class=" " | Row1
 
| class=" " | Row1
 
| class="sshl_f " | 2
 
| class="sshl_f " | 2
−
| class="                                     " |
+
| class=" " |
−
| class="                                                                       " |
+
| class=" " |3
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
|- class="even"
Line 46: Line 31:
 
| class="sshl_f" | 5
 
| class="sshl_f" | 5
 
| class=" " |
 
| class=" " |
 +
| class=" " |7
 
| class=" " |
 
| class=" " |
 +
|- class="odd"
 +
| class="  " | Row3
 +
| class="sshl_f" |
 
| class=" " |
 
| class=" " |
−
|- class="odd"
+
| class=" " |9
−
| 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=" " |
 
|- class="even"
 
|- class="even"
−
| Row4
+
| class=" " | Row4
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
−
| class="   " |
+
| class=" " |11
 
| class=" " |
 
| class=" " |
 
|- class="odd"
 
|- class="odd"
Line 65: Line 49:
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
−
| class=" " | 10027
+
| class=" " |  
−
| class="                      " |
 
−
|- class="even"
 
−
| Row6
 
−
| class=" " |
 
 
| class=" " |
 
| class=" " |
−
| class="      sshl_f  sshl_f    " |
 
−
| class="    " |
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
=ROWS(D4)  : Calculates the row number of cell D4. ''Returns 4'' as a result.
−
----
+
=ROWS(A2:C5): Calculates the row numbers in the range A2 to C5. ''Returns 4'' as a result.
 +
=ROWS([3,4;6,7;8,9]): Calculates the number of rows from the given array. ''Returns 3'' as a result.
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|jkd2REKwmIs|280|center|ROWS}}
 +
 
 +
== See Also ==
 +
 
 +
*[[Manuals/calci/ROW| ROW]]
 +
 
 +
==References==
 +
 
 +
*[http://en.wikipedia.org/wiki/Row_(database) Row]
 +
 
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 15:36, 9 August 2018

ROWS (Array)


  • where is an array or reference
    • ROWS() displays the number of rows in an array or reference.

Description

ROWS()

  • For Example,ROWS(B4) returns 1.
  • can be a cell, range of cells or an array.


Examples

ColumnA ColumnB ColumnC ColumnD
Row1 2 3
Row2 5 7
Row3 9
Row4 11
Row5 
=ROWS(D4)   : Calculates the row number of cell D4. Returns 4 as a result.
=ROWS(A2:C5): Calculates the row numbers in the range A2 to C5. Returns 4 as a result.
=ROWS([3,4;6,7;8,9]): Calculates the number of rows from the given array. Returns 3 as a result.

Related Videos

ROWS

See Also

References



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ROWS&oldid=210998"