For example, in a workbook that contains 5 sheets, the following formula will return 5: SHEETS can be used to report the sheet count in 3D references as well. For example, in a workbook with three sheets (Sheet1 through Sheet3) in numeric order, the formulas below return results as shown:


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

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.