Wauvel

Excel like a finance pro.

← The library

Information function

SHEETS

Returns the number of sheets in a reference or the workbook.

Rarely usedDifficulty 1150 · ProficientUsage rank #257 of 520
Practice · 2 questions →

When to use it

How many sheets a workbook or a 3D reference spans.

The shape of it

Syntax
=SHEETS([reference])

Worked examples

  • Whole workbook

    =SHEETS() → 5

    Five tabs, including hidden ones.

  • One sheet

    =SHEETS(A1:B2) → 1

    A normal reference is one sheet.

  • 3D reference

    =SHEETS(Jan:Dec!A1) → 12

    A 3D reference across twelve monthly sheets.

Worth knowing

  • Verify a 3D SUM covers the number of months you expect.
  • Counts hidden and very hidden sheets.
  • Introduced in Excel 2013.

Where it goes wrong

  • Does not count chart sheets separately in all versions.
  • Rarely needed.

Related

ISBLANKISNUMBERISERRORISTEXTISNANA

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.