SHEET and SHEETS

New Excel function in Excel 2013

The SHEET function returns the number of the referenced worksheet.
The SHEETS function returned the number of worksheets in reference.

Syntax

SHEET([reference])

The optional reference is either a cell range or text.

Comments

The reference can be text, a cell reference or named range.

If the reference is blank, SHEET will return the sheet number of the worksheet that it is in. SHEETS will return the total number of worksheets in the workbook.

The SHEETS function counts sheets even if they have been hidden

If the reference is not valid, a #N/A error is returned. If the reference is a named range that does not have a global scope, a #NAME? error is returned.

Examples