SHEETS Function Explained
The SHEETS Function in Microsoft Excel returns the number of sheets in a reference. It takes a single argument, which is a reference to a range of cells, and returns the number of sheets in that reference.
SHEETS Function Syntax
SHEETS(reference)
- reference: The reference for which you want the number of sheets. Reference can refer to a range of cells or named range.