Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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: