Related Function:

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.

Syntax

=SHEETS([reference])

Arguments

Argument Description
[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.

Examples

  A B C
1 Formula Result Notes
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