SHEETS function
The SHEETS function is one of the information functions. It is used to return the number of sheets in a reference.
Syntax
SHEETS([reference])
The SHEETS function has the following argument:
| Argument | Description |
|---|---|
| reference | A reference for which you want to find out the number of sheets it contains. It is an optional argument. If reference is omitted, the number of sheets in the current workbook is returned. |
Notes
How to apply the SHEETS function.
Examples
The figure below displays the result returned by the SHEETS function.
