Difference between revisions of "Documentation/How Tos/Calc: ROWS function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m (→See also:) |
||
| Line 20: | Line 20: | ||
=== See also: === | === See also: === | ||
| − | '''[[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS | + | '''[[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]]''', |
| − | '''[[Documentation/How_Tos/Calc: SHEETS function|SHEETS | + | '''[[Documentation/How_Tos/Calc: SHEETS function|SHEETS]]''' |
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''', | '''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''', | ||
'''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]''' | '''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]''' | ||
Revision as of 17:15, 25 January 2008
ROWS
Returns the number of rows in a given range.
Syntax:
ROWS(range)
- range is a range of cells.
Example:
ROWS(A3:B5)
- returns 3; there are three rows in this range, namely rows 3,4 and 5.
ROWS(G4:G6)
- returns 3; there are three rows in this range, namely rows 4,5 and 6.
ROWS(D8)
- returns 1; D8 is interpreted as a one cell range, with a single row (row 8).
