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.
Returns a positive whole number ranging from 1 to 32,000 which is the number of sheets in the Reference or current document.
Reference is the reference to a sheet or a named area.
- If Reference is an invalid value then the function returns an error value.
- Hidden sheets are not excluded from the sheet count.
|=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:
Equivalent Excel functions: