ExcelFlux

SHEETS function

the number of sheets in a reference.

Information · Excel 2013+ · Guided Excel example

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

The workbook has two language tabs, so the result is two in each trial.

A worked example from the workbook

RowA
6Trial
71
82
93
Record 1
=SHEETS()

Illustrative output2

See the inputs and instructions for all 3 examples

Worked examples

The workbook has two language tabs, so the result is two in each trial.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Trial
7 1
8 2
9 3
Trial Expression Sample output
Record 1 =SHEETS() 2
Record 2 =SHEETS() 2
Record 3 =SHEETS() 2
Microsoft Excel reference