Function to get the number of sheets present in a workbook or cell range.
It is used in books where the number of sheets increases over a period of time, and has uses such as keeping track of the number of sheets present in a workbook or incorporating it into other formulas.
How it works
=SHEETS(reference)
| Specify reference | Results |
|---|---|
| Omitted. | Number of all worksheets in the workbook. |
| Cell. | Because only one sheet is needed in the normal cell specification. |
| Cell range (3D). | Number of sheets skewered. |
| Cells in a separate file. | #N/A Error. |
Example Results
---