Article updated on May 04, 2018

The SHEETS function returns the number of sheets in a reference. It returns the number of sheets in a workbook if the argument is omitted.

Formula in cell D3:

=SHEETS(Sheet2:Sheet3!A1:B2)

Excel Function Syntax

SHEETS(reference)

Arguments

reference Optional. The reference you want to determine the number of sheets it contains.