Difference between revisions of "Manuals/calci/ROWS"
Jump to navigation
Jump to search
(Replaced content with "== ROWS(array) == *where <math>array</math> is an array or reference ROWS() displays the number of rows in an array or reference. == Description == ROWS(array) For Ex...") |
|||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | = | + | <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. | ||
| + | |||
| + | == Description == | ||
| + | |||
| + | ROWS() | ||
| + | *For Example,ROWS(B4) ''returns 1''. | ||
| + | *<math>Array</math> can be a cell, range of cells or an array. | ||
| − | |||
| − | + | == Examples == | |
| − | == | + | <div id="4SpaceContent" class="zcontent" align="left"> |
| + | |||
| + | {| id="TABLE2" class="SpreadSheet blue" | ||
| + | |- class="even" | ||
| + | | class=" " | | ||
| + | | ColumnA | ||
| + | | ColumnB | ||
| + | | ColumnC | ||
| + | | ColumnD | ||
| + | |- class="odd" | ||
| + | | class=" " | Row1 | ||
| + | | class="sshl_f " | 2 | ||
| + | | class=" " | | ||
| + | | class=" " |3 | ||
| + | | class=" " | | ||
| + | |- class="even" | ||
| + | | class=" " | Row2 | ||
| + | | class="sshl_f" | 5 | ||
| + | | class=" " | | ||
| + | | class=" " |7 | ||
| + | | class=" " | | ||
| + | |- class="odd" | ||
| + | | class=" " | Row3 | ||
| + | | class="sshl_f" | | ||
| + | | class=" " | | ||
| + | | class=" " |9 | ||
| + | | class=" " | | ||
| + | |- class="even" | ||
| + | | class=" " | Row4 | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " |11 | ||
| + | | class=" " | | ||
| + | |- class="odd" | ||
| + | | class=" " | Row5 | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | |} | ||
| + | |||
| + | =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 16:36, 9 August 2018
ROWS (Array)
- where is an array or reference
- ROWS() displays the number of rows in an array or reference.
is 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
See Also
References