Skip to content
Google Sheets

SHEETS function in Google Sheets

Returns the total number of sheets in the referenced spreadsheet. .

=SHEETS(reference)

SHEETS syntax and parameters

One argument, zero required.

  • referencerangeOptional

    [ OPTIONAL ] - Reference identifies the number of sheets. If reference isn’t included, SHEETS returns the number of sheets in the workbook that contains the function.

SHEETS examples

Formulas you'll actually reuse.

  1. How many sheets the workbook has:

    =SHEETS()

    Result6

  2. A “tab 2 of 6” label from the sheet position and count:

    ="Region " & SHEET() & " of " & SHEETS()

    Result"Region 2 of 6"

SHEETS in Excel

Same name — your formula ports as-is.

Try SHEETS in the playground

Edit the example — nothing to install.

Preloaded with the SHEETS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.