Author: Oscar Cronquist Article last updated on May 06, 2022

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.