Lógicas

Función SHEETS de Excel

Returns the number of sheets in a reference.

Sintaxis

SHEETS([reference])

Generar SHEETS con IA Todas las funciones

Argumentos

referenceopcional

The reference for which you want to know the number of sheets; if omitted, returns the total sheets in the workbook.

Qué hace la función SHEETS

The SHEETS function counts the total number of sheets within a specified reference. If the reference argument is omitted, it returns the total number of sheets in the current workbook.

Ejemplos

=SHEETS()→3

Returns the total number of sheets in the current workbook.

=SHEETS(Sheet1:Sheet3!A1)→3

Returns the number of sheets included in the 3D reference from Sheet1 to Sheet3.

Cómo usar SHEETS

Select a cell

Click on the cell where you want to display the sheet count.

Enter the function

Type =SHEETS() and press Enter to see the total number of sheets in your workbook.

Preguntas frecuentes

Does SHEETS count hidden sheets?

Yes, the SHEETS function counts all sheets in the workbook, including those that are hidden.

Funciones relacionadas

SHEET