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.
SHEETS function - The function returns the number of pages in a reference in Excel Picture 1
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:
SHEETS function - The function returns the number of pages in a reference in Excel Picture 2
- In the cell to calculate enter the formula : = SHEETS (C6)
SHEETS function - The function returns the number of pages in a reference in Excel Picture 3
- Press Enter -> return value is:
SHEETS function - The function returns the number of pages in a reference in Excel Picture 4
- Similarly copying the formula for the remaining values results:
SHEETS function - The function returns the number of pages in a reference in Excel Picture 5
- In case of omitting reference parameter -> function returns the total number of sheets of the current working window.
SHEETS function - The function returns the number of pages in a reference in Excel Picture 6
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
May be interested
TYPE function - Function that returns the data type of any value in Excel
NA function - The function returns the # N / A error value in Excel
Guide to familiarize yourself with Excel
How to create the first Workbook in Excel
How to use functions to identify and calculate date information in Excel
STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel