Difference between revisions of "Manuals/calci/ROWS"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | == ROWS( | + | == ROWS(arr) == |
| − | *where <math> | + | *where <math>arr</math> is an array or reference |
ROWS() displays the number of rows in an array or reference. | ROWS() displays the number of rows in an array or reference. | ||
| Line 7: | Line 7: | ||
== Description == | == Description == | ||
| − | ROWS( | + | ROWS(arr) |
For Example, | For Example, | ||
| Line 13: | Line 13: | ||
ROWS(B4) ''returns 1''. | ROWS(B4) ''returns 1''. | ||
| − | *<math> | + | *<math>arr</math> can be a cell, range of cells or an array. |
| Line 60: | Line 60: | ||
=ROWS(D4) : Calculates the row number of cell D4. ''Returns 4'' as a result. | =ROWS(D4) : Calculates the row number of cell D4. ''Returns 4'' as a result. | ||
| − | =ROWS(A2:C5): Calculates the row | + | =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. | ||
== See Also == | == See Also == | ||
Revision as of 18:13, 12 December 2013
ROWS(arr)
- where is an array or reference
is an array or referenceROWS() displays the number of rows in an array or reference.
Description
ROWS(arr)
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.