SHEETS
Returns the number of sheets in a reference
Syntax
SHEETS([reference])
Parameters
- reference: Optional. A reference for which you want to know the number of sheets it contains. If omitted, returns the total number of sheets in the workbook
Example
=SHEETS()