SHEETS
Number of sheets in a reference.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number
Examples
=SHEETS() Result 1
Syntax
SHEETS([reference]) reference- range optional
Related
CELLInformation about a cell's formatting, location or contents. ERROR.TYPEReturns number corresponding to an error type. FORMULATEXTReturns formula as a text string. INFOInformation about the operating environment. ISBLANKReturns TRUE if value is blank. ISDATETrue when a value can be read as a date.