Excel functions / Information

SHEETS function

How many sheets the workbook has.

Syntax

=SHEETS([reference])

Arguments

When to use it

SHEETS gives the number of sheets in the workbook. It is used in a summary sheet to check that every month's sheet is there.

Examples

  1. Sheets in this workbook

    AB
    1Sheets1

    In B1: =SHEETS() → 1

    Try this example

Common mistakes

SHEETS in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try SHEETS in the playground

Related functions