Summary

SHEETS returns the number of sheets in a workbook or reference. If you leave the argument out, it returns the total sheet count for the current workbook.

This makes it useful for workbook audits, template checks, and formulas that need to know how many sheet layers are involved.

Syntax

=SHEETS([reference])

The argument is optional. Without it, Excel counts the sheets in the current workbook.

Arguments

• reference - [optional] A reference whose sheet span you want to count.

SHEETS vs SHEET

Using SHEETS

This function works well when a workbook has a required structure. If a template should contain a certain number of tabs, SHEETS() gives you a quick way to test whether that structure is still intact.

It is also useful with 3D references. A formula like SHEETS(Sheet1:Sheet5!A1) counts the number of sheets in that reference span, which helps when you are checking multi-sheet calculations.

Example 1 - Count all sheets in the workbook

This is the default use.

=SHEETS()

Example 2 - Count a 3D reference span

This returns the number of sheets between the start and end tabs in the reference.

=SHEETS(Sheet1:Sheet5!A1)

Example 3 - Compare the actual count to an expected one

This is a simple workbook health check.

=IF(SHEETS()<10,"INCOMPLETE","READY")

Example 4 - Check a single-sheet reference

A normal reference like A1 covers one sheet, so the result is 1.

=SHEETS(A1)

Conclusion Recap

• Main job: SHEETS counts sheets.
• No argument: It returns the total workbook sheet count.
• With a reference: It counts the sheets covered by that reference.
• Good use: Workbook audits and 3D reference checks.