Excel SHEETS Function

HomeExcel FunctionsExcel SHEETS Function (Example + Sample File)

What is EXCEL SHEETS FUNCTION

The Excel SHEETS Function is listed under Microsoft Excel's Information Functions category. It returns a count of the worksheets from the referred range. In simple words, with SHEETS function you can count how many sheets are in the range you have referred.

How to use it

To learn how to use the SHEETS function in Excel, you need to understand its syntax and arguments: 

Syntax

SHEETS(reference)

Arguments

  • reference: The Reference for which you want to count numbers of sheets.

Notes

  • It will include all types of sheets (Chart Sheet, Worksheet or Macro Sheet).
  • You can refer to sheets even if they are visible, hidden or very hidden.
  • If you skip specifying any value in the function it will give you the count of total sheets in a workbook.
  • If you specify an invalid reference, it will return a #REF!.

Example

To master the SHEETS function we need to try it out in an example and below is one which you can try out:

In the below example, we have used 3D cell reference to get the sum of cell A1 from five sheets and we have used the same reference to get the count of sheets.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.