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:


Excel Function Syntax



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