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!
You should read it
- How to use ADDRESS function in Excel
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- ISREF function - The function returns True if the value is a valid reference value in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- PERMUT function - The function returns the number of permutations of a given number of objects in Excel
- The DAYS function - The function returns the number of days between 2 dates in Excel
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- The OFFSET function returns a reference in Excel
- ISODD function - The function returns True if the value is an odd number in Excel
- POISSON function - The function returns the Poisson distribution in Excel
- BETA.DIST function - The function returns the Beta distribution in Excel
Maybe you are interested
How to turn a photo into a painting using the Generative Fill function in Photoshop
How to use the TREND function in Excel
Google Sheets Functions to Simplify Your Budget Spreadsheets
Instructions for using the TRIMRANGE function to clean up Excel tables
How to master numerical data in Google Sheets with the AVERAGE function
Don't buy headphones if they lack this important function!