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...") |
|||
| Line 17: | Line 17: | ||
== Examples == | == 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 number in the range A2 to C5. ''Returns 4'' as a result. | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/ROW| ROW]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Row_(database) Row] | ||
Revision as of 17:50, 12 December 2013
ROWS(array)
- where is an array or reference
is an array or referenceROWS() displays the number of rows in an array or reference.
Description
ROWS(array)
For Example,
ROWS(B4) returns 1.
- can be a cell, range of cells or an array.