Difference between revisions of "Manuals/calci/ROWS"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | |||
<div style="font-size:30px">'''ROWS (Array) '''</div><br/> | <div style="font-size:30px">'''ROWS (Array) '''</div><br/> | ||
*where <math>Array</math> is an array or reference | *where <math>Array</math> is an array or reference | ||
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.
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