Menu
EXCEL SHEETS FUNCTION
Excel SHEETS Function Introduction
The Sheets function in Excel returns the number of sheets in a given reference. As a consequence, there are sheets that are Visible, Hidden, or Very Hidden.
Description of Excel SHEETS Function
Syntax :
=SHEETS( [reference] )
Parameters :
- The [reference] input given is a reference for which you wish to know the number of sheets. This is an optional parameter that, if left blank, returns to the current workbook.
Step By Step Guide of SHEETS Function
Example :
The spreadsheets below illustrate how the Excel Sheets function is used in a three-sheet Excel file.
Key Points
- SHEETS encompasses all worksheets (visible, hidden, or extremely hidden) as well as all other sheet kinds (macro, chart, or dialogue sheets).
- SHEETS provides the #REF! error result if references is not a valid value.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
