Article updated on February 21, 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:


Excel Function Syntax



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