Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SHEETS
SHEETS counts the total number of worksheets in the current workbook when called with no argument, or counts the sheets spanned by a 3D reference. It is useful for building dynamic summaries that automatically account for added or removed tabs without updating formula arguments.
Excel
=SHEETS()Google Sheets
=SHEETS()✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Description | Value |
| Total sheets | 5 |
| Current sheet | 2 |
| Remaining | 3 |
=SHEETS()→1
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Use =SHEETS() with no argument to count all sheets in the workbook.
- 2Pass a 3D range like Sheet1:Sheet3!A1 to count the sheets included in that reference.
- 3Combine with SHEET() to determine a sheet's position relative to the total: =SHEET()/SHEETS().
Need a version for your data?
Try: “Count how many worksheet tabs are in my workbook so I can display it on a summary page”