navigation

SHEETS function - The function returns the number of pages in a reference in Excel

The following article introduces you to the SHEETS function - one of the functions in the information function group is very popular in Excel.

Description: The function returns the number of pages in a reference. Support functions from Excel 2013 onwards.

Syntax: SHEETS (reference)

Inside:

- reference: A reference to find the page number, is the required parameter.

Attention:

- SHEETS function includes all worksheets, along with all types of macro pages, charts .

- If the reference value is not valid -> the function returns the #REF! Error value

- SHEET function should not be used in the object model because that model already has similar features.

- In case of omitting reference parameter, the function returns the total number of pages in the current working window.

For example:

Calculate the number of pages in a reference described in the table below:

- In the cell to calculate enter the formula : = SHEETS (C6)

- Press Enter -> return value is:

- Similarly copying the formula for the remaining values ​​results:

- In case of omitting reference parameter -> function returns the total number of sheets of the current working window.

Above are instructions and some specific examples when using SHEETS function in Excel.

Good luck!

Update 19 May 2020