Rational
Find count of worksheets in a workbook.
Description
The Excel SHEETS function finds the total number of sheets in a workbook of a reference argument. In the case of empty parenthesis or no argument in the [reference] parameter, the function returns a count of the worksheet in the active workbook.
Syntax
=SHEETS([reference])
Parameters
reference [optional] – A valid sheet reference
Return Value
Number of sheets
Key Notes
- SHEETS function is useful to find the number of sheets in an Excel workbook.
- The function also counts hidden sheets in the workbook.
To count number of sheets in a workbook for example we will apply Formula =SHEETS() it return 3 after counting sheets in a workbook.