Return to List of Excel Functions

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

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions