< Go Back

Excel SHEETS Function

Excel SHEETS Function

Generic Formula

= SHEETS([reference])

Reference is optional. If a reference is omitted, the formula returns the number of the sheets in the workbook.

Example:

Below is some of the example of using this formula

Figure 1 – Excel SHEETS Function

Explanation

The formula in E4 =SHEETS(), the result is 4 as the current workbook has 4 sheets

The formula in E5 =SHEETS(Table1) returns 1 because Table1 is in the current bookwork only

The formula in E7 =SHEETS(Sheets1:Sheets2!A3) return 2 because Sheets1:Sheets2!A3 refer to a range of 2 sheets

Note

  • The SHEETS function can include hidden sheets in the count
  • The SHEET function returns an index of the sheets while the SHEETS function returns the number of sheets.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar