If the SHEET function is a function that returns the value of the sheet number of the worksheet, the SHEETS function in Excel returns the number of pages in a reference in Excel. .
What is the SHEETS function in Excel? This function returns the number of pages in a reference, in other words, this function returns the number of pages in a reference in MS Excel.
SHEETS function in Excel
How to use the SHEETS function in Excel
1 Description and syntax used:
This is a function that returns the number of pages in a reference. Support functions from Excel 2013 onwards.
Syntax: SHEETS (reference)
Inside: Reference: The reference to find the page number, is the required parameter.
– SHEETS function includes all worksheets, along with all types of macro pages, charts …
– If the Reference value is not valid -> the function returns an error value #REF!
– SHEETS 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.
2. Example of specific situation:
Suppose you need to calculate the number of pages in a reference described in the table below:
In the cell to calculate -> you enter the formula: = SHEETS (B3)
Press Enter -> return value result is:
Similarly, you copy the formula for the remaining values in the lines below and get the result:
If you omit the Reference parameter -> the function returns the total number of sheets in the current workbook.
Above I just introduced and guide you about SHEETS function in Excel is a calculation function that returns the number of pages in a reference. The syntax is SHEETS (reference), where Reference is the reference to find the page number and the required parameter.
Wish you remember the formula and succeed in working with this formula.