SHEETS Function in Excel 2013, 2016, 2019

Buzz

Ngày cập nhật gần nhất: 1/5/2026

Content

SHEETS Function in Excel

How to Use the SHEETS Function in Excel

1. Description and Syntax:

2. Specific Scenario Example:

In this article, Mytour will delve into the SHEETS function in Excel 2012, 2016, 2019 to offer you a deeper understanding of this function and how to use it effectively, alongside the SHEET function.

What is the SHEETS function in Excel? This function returns the number of sheets in a reference or, in other words, the number of sheets within a reference in MS Excel.

SHEETS Function in Excel

How to Use the SHEETS Function in Excel

1. Description and Syntax:

This function calculates and returns the number of sheets within a reference. It is supported from Excel 2013 onwards.

Syntax: SHEETS(reference)

In which: Reference: Is the reference to find the number of sheets, it's a mandatory parameter.

Note:
- The SHEETS function includes all worksheets, along with all types of sheet elements like macros, charts...
- If the Reference value is invalid -> the function returns an error value #REF!
- Avoid using the SHEETS function in object models as they already possess similar functionalities.
- If you omit the Reference parameter, the function returns the total number of sheets in the current workspace.

2. Specific Scenario Example:

Suppose you need to calculate the quantity of pages within a reference described in the table below:

In the cell where calculation is needed -> input the formula: =SHEETS(B3)

Press Enter -> the returned value result is:

Similarly, copy the formula for the remaining values in the rows below and get the result:

In case you omit the Reference parameter -> the function returns the total number of sheets within the current workspace.

Here I've just introduced and guided you through the SHEETS function in Excel, which calculates the number of sheets within a reference. Its syntax is SHEETS(reference), where Reference is the reference to count sheets for and is a required parameter.

Wishing you swift mastery and success with formulas related to this function.

Frequently Asked Questions

What is the primary purpose of the SHEETS function in Excel?

The SHEETS function in Excel is designed to return the total number of sheets in a specified reference. This function, supported from Excel 2013 onwards, includes all types of sheets, such as worksheets, macros, and charts. If the reference is invalid, it will result in a #REF! error, indicating that the input needs correction.

How do you correctly use the SHEETS function in Excel 2016?

To use the SHEETS function in Excel 2016, enter the formula =SHEETS(reference) into the desired cell. Replace 'reference' with the appropriate sheet reference to count. If you omit the reference parameter, it automatically counts the total number of sheets in your current workbook, providing a quick overview of your workbook's structure.

Can the SHEETS function be used to count different types of sheets?

Yes, the SHEETS function can count various types of sheets within a workbook, including regular worksheets, charts, and macro sheets. This functionality allows users to gain insights into their workbook's organization, ensuring they can manage their data effectively.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]