Documentation/Calc Functions/SHEETS
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
SHEETS
Category:
Spreadsheet
Summary:
Determines the number of sheets in a reference. If you do not enter any parameters, it returns the number of sheets in the current document.
Syntax:
SHEETS(Reference)
Returns:
Returns a positive whole number ranging from 1 to 32,000 which is the number of sheets in the Reference or current document.
Arguments:
Reference is the reference to a sheet or a named area.
- If Reference is an invalid value then the function returns an error value.
Additional details:
- Hidden sheets are not excluded from the sheet count.
Examples:
Formula | Description | Returns |
---|---|---|
=SHEETS(Sheet1.A1:Sheet3.G12) | The function counts Sheet1, Sheet2, and Sheet3. | 3 |
=SHEETS() where the document contains 2 sheets | Since no Reference is available the function counts all sheets a document contains. | 2 |
=SHEETS(MySheets) where "MySheets" is a named area containing Sheet1.A1:Sheet2.G12 | The function counts Sheet1 and Sheet2 from the named area. Here we are using 3D referencing. | 2 |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
SHEETS