| 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] |