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!