The Excel SHEETS function counts the total number of sheets in a reference. SHEETS will report the number of sheets for a cell reference, named range, or Excel Table.
Purpose of Excel SHEETS Function
To get a number of sheets in a given reference.
Return value
SHEETS returns the number of sheets.
Syntax
=SHEET ([value])
Arguments
| Arguments | Description | Remarks |
| [value] | The value to check. | Optional |
Usage notes
- SHEETS includes all worksheets (visible, hidden, or very hidden) in addition to all other sheet types (macro, chart, or dialog sheets).
- If reference is not a valid value, SHEETS returns the #REF! error value.
Availability
Since 2013 for Windows.
Since 2016 for Mac.