Functions
SHEETS
Number of sheets in a reference or workbook
When to use it
When should I use SHEETS?
Use SHEETS to return the total number of sheets in a workbook or in a multi-sheet reference, useful for dynamic formulas that must iterate over every sheet.
Used in
Syntax
SHEETS([reference])