# Documentation/Calc Functions/SHEETS

SHEETS

## 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.

• 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

SHEETS