Excel functions / Information
SHEETS function
How many sheets the workbook has.
Syntax
=SHEETS([reference])
Arguments
reference(optional): A reference, to count the sheets it covers. Left out, every sheet of the workbook is counted.
When to use it
SHEETS gives the number of sheets in the workbook. It is used in a summary sheet to check that every month's sheet is there.
Examples
Sheets in this workbook
A B 1 Sheets 1 In B1:
=SHEETS()→ 1
Common mistakes
- Hidden sheets. In Excel, hidden sheets are counted too.
SHEETS in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SHEETS
- Danish: ARK.FLERE
- Dutch: BLADEN
- Finnish: TAULUKOT
- French: FEUILLES
- German: BLÄTTER
- Hungarian: LAPOK
- Italian: FOGLI
- Norwegian: ANTALL.ARK
- Polish: ARKUSZE
- Portuguese (Portugal): FOLHAS
- Russian: ЛИСТЫ
- Spanish: HOJAS
- Turkish: SAYFALAR