SHEETS function

Category: Information
Introduced: Excel 2013

Summary

Returns the number of sheets in a reference

Syntax

SHEETS(reference) The SHEETS function syntax has the following arguments.
• Reference Optional. Reference is a reference for which you want to know the number of sheets it contains. If Reference is omitted, SHEETS returns the number of sheets in the workbook that contains the function.

Example

=SHEETS()
=SHEETS(My3DRef)

Microsoft Support Page

https://support.microsoft.com/en-us/office/sheets-function-770515eb-e1e8-45ce-8066-b557e5e4b80b

Back to Functions