SHEETS function. Get the number of worksheets.(Microsoft Excel)
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

---
Discussion
New Comments
No comments yet. Be the first one!