SHEETS

Find count of worksheets in a workbook in Excel
Returns the number of sheets in a reference

Rational

Find count of worksheets in a workbook.

Description

The Excel SHEETS function finds the total number of sheets in a workbook of a reference argument. In the case of empty parenthesis or no argument in the [reference] parameter, the function returns a count of the worksheet in the active workbook.

Syntax

=SHEETS([reference])

Parameters

reference [optional] – A valid sheet reference

Return Value

Number of sheets

Key Notes

  • SHEETS function is useful to find the number of sheets in an Excel workbook.
  • The function also counts hidden sheets in the workbook.

To count number of sheets in a workbook for example we will apply Formula =SHEETS() it return 3 after counting sheets in a workbook.

 

Keep Reading Similar Functions: