SHEETS
Returns the number of sheets in a reference.
InformationInformation & Auditing
What it does
Returns the number of sheets in a workbook or reference.
Syntax
SHEETS([reference])
Arguments
reference(reference) — Reference (optional).
Examples
Count Sheets
Count total sheets.
FORMULA
=SHEETS()
RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Info |
| 2 | (3 Sheets) |