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:
- reference: The Reference for which you want to count numbers of sheets.
- 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!.
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.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL CELL Function
- EXCEL ERROR.TYPE Function
- EXCEL INFO Function
- EXCEL ISBLANK Function
- EXCEL ISERR Function
- EXCEL ISERROR Function
- EXCEL ISEVEN Function
- EXCEL ISFORMULA Function
- EXCEL ISLOGICAL Function
- EXCEL ISNA Function
- EXCEL ISNONTEXT Function
- EXCEL ISNUMBER Function
- EXCEL ISODD Function
- EXCEL ISREF Function
- EXCEL ISTEXT Function
- EXCEL N Function
- EXCEL NA Function
- EXCEL SHEET Function
- EXCEL TYPE Function
About the Author
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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.