SHEETS Function Examples – Excel Sheets

This Tutorial demonstrates how to use the Excel SHEETS Function in Excel to returns the total number of sheets in a given reference.

SHEETS Main Function

SHEETS Function Overview

The SHEETS Function Calculates the number of sheets in a given reference.

To use the SHEETS Excel Worksheet Function, select a cell and type:

SHEETS Function

(Notice how the formula inputs appear)

SHEETS function Syntax and inputs:

=SHEETS ([reference])

reference – [optional] A valid Excel reference.

SHEETS Function

The SHEETS Function returns the total number of sheets in a workbook.

=SHEETS()

SHEETS EX 01

SHEETS Function – Sheet Reference

The SHEETS Function can also return the number of sheets in a given sheet reference.

=SHEETS(Sales:Process!A1)

SHEETS EX 02