SHEETS Function

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.

SHEETS is mainly about workbook structure rather than cell content. It helps count how many sheets are involved, which can be useful in audits, dynamic references, and checks where the size of the workbook or a sheet range matters to the formula logic.

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 example uses SHEETS() with no argument, so Excel returns the total number of worksheets in the workbook. It answers the question "how many tabs are there overall?"

That can be useful in workbook audits, control sheets, or checks that depend on the file having the expected number of tabs.

=SHEETS()

Example 2 - Check the workbook sheet count

This example compares the workbook sheet count to the number you expect. It is a simple way to confirm that the workbook still has the required number of tabs.

That can be useful in control sheets, setup checks, or any workbook that should always contain a fixed set of sheets.

=SHEETS()=5

Example 3 - Compare the actual count to an expected one

Here, the sheet count is being turned into a quick status message. Instead of only returning the number, the formula checks whether the workbook has reached an expected minimum size.

This is a practical pattern when a workbook should contain a full set of tabs before it is considered ready, complete, or safe to use.

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

Example 4 - Check a single-sheet reference

This example keeps the reference small so the behavior is easy to see. A normal cell reference belongs to one sheet only, so the result is 1.

It helps show that SHEETS is really counting the sheet span of the reference you give it, not the number of cells inside that reference.

=SHEETS(A1)

Conclusion Recap

SHEETS is useful when you care about how many tabs are involved, not where one tab sits. In this lesson, that meant checking total workbook size, counting tabs inside a 3D reference, and making sure a template still has the structure it should have.

The easiest way to remember it is count versus position. SHEETS() gives a total, while SHEET() gives one sheet number.

• 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.