SHEETS function in Excel 2013, 2016, 2019


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.

Attention:

– 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:

ham sheets in excel 2

In the cell to calculate -> you enter the formula: = SHEETS (B3)

ham sheets in excel 3

Press Enter -> return value result is:

ham sheets in excel 4

Similarly, you copy the formula for the remaining values ​​in the lines below and get the result:

ham sheets in excel 5

If you omit the Reference parameter -> the function returns the total number of sheets in the current workbook.

ham sheets in excel 6

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.

https://thuthuat.taimienphi.vn/ham-sheets-rong-excel-43721n.aspx
Wish you remember the formula and succeed in working with this formula.

.

Add a Comment

Your email address will not be published. Required fields are marked *