The SHEETS function returns the number of sheets in a supplied reference. The result includes sheets that are Visible, Hidden or Very Hidden.
- This function was introduced in Excel 2013 and so is not available in earlier versions.
|[reference]||The [reference] argument is a reference to an Excel sheet or a part of an Excel sheet. This is an optional argument which, if omitted, defaults to the current workbook.|
|2||=SHEETS()||3||defaults to the current workbook which has 3 sheets|
|3||=SHEETS(A1)||1||A1 refers to a range on just 1 worksheet|
|4||=SHEETS(Sheet1:Sheet2!A1)||2||refers to a range on 2 sheets|