Exceljet

Quick, clean, and to the point

Excel SHEETS Function

Excel SHEETS function
Summary 

The Excel SHEETS function returns the total number of sheets in a given reference.  When no arguments are supplied SHEETS returns the total number of sheets in the workbook.

Purpose 
Get number of sheets in a reference
Return value 
Sheet count
Syntax 
=SHEETS ([reference])
Arguments 
  • reference - [optional] A valid Excel reference.
Version 
Usage notes 

Use the SHEETS function to get the total number of sheets in a given reference. When no arguments are supplied, SHEETS returns the total number of sheets in the workbook. The SHEETS function includes hidden sheets.

For example, in a workbook that contains 3 sheets, the following formula will return 3:

Sheets can be used to report the sheet count in 3D references as well. For example, the following formula will return 2:

=SHEETS(Sheet1:Sheet2!A1)

Notes

  • If the reference is omitted, SHEETS returns total sheet count in a workbook
  • The SHEETS function includes hidden sheets in the count
  • SHEETS will report sheet count in 3D references
  • SHEET reports the index of a sheet, the SHEETS function reports the number of sheets in a reference

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas