SHEETS in WPS Spreadsheet on Windows returns the number of worksheets included in a reference; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
The SHEETS function in WPS Spreadsheet is a built-in formula used to return the total number of worksheets included in a reference. It is useful for workbook checks, multi-sheet formula review, and worksheet structure confirmation.
Core tasks include:
- Find and insert the SHEETS function from the Insert Function dialog box.
- Type
=SHEETS(...)directly in a cell or in the formula bar. - Review the function syntax and parameter guidance before entering a formula.
This page is helpful if you want to use the SHEETS function in WPS on Windows for worksheet counting and formula entry.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory internet connection is required for local formula entry and calculation; internet access is needed for downloads or online help pages |
| Other | WPS Office should be installed, and you should be able to open a spreadsheet file for formula editing |
Download & Installation
Before using the SHEETS function, install WPS Office on your Windows device.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet and any workbook, then confirm that the Formula tab includes the Insert Function entry |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Spreadsheet provides the SHEETS function to return the number of worksheets included in a reference, and it can be used through Insert Function or direct formula entry. | Excel provides the SHEETS function and states that if the reference argument is omitted, it returns the number of sheets in the workbook that contains the function. | Google Sheets provides the SHEETS function and states that it returns the total number of sheets in the spreadsheet, with an optional reference argument. | Notion provides a formula language with properties, built-ins, and functions for database calculations, rather than a worksheet-counting function in a spreadsheet workbook. | Adobe Acrobat provides calculated PDF form fields for sums, products, averages, minimums, and maximums, rather than a spreadsheet worksheet-counting function like SHEETS. |
| WPS Advantages | Advantage: It fits directly into a spreadsheet formula workflow for workbook checks and worksheet counting. Distinct: Users can insert it from a dialog box or type it directly in the formula bar. | Compared with WPS: Excel offers a closely matched worksheet function and is suitable for users already working in Microsoft 365. | Compared with WPS: Google Sheets offers a similar function but is centered more on browser-based spreadsheet collaboration. | Compared with WPS: Notion formulas are designed for database properties and row-level calculations instead of multi-worksheet workbook formulas. | Compared with WPS: Acrobat calculations are designed for PDF form fields, not worksheet references inside spreadsheet files. |
| Official Source | — | SHEETS function | SHEETS function | Formula syntax and functions | Configure form field calculations in Acrobat |
Overall Conclusion: If your work centers on spreadsheet formulas, workbook review, and worksheet counting, WPS Spreadsheet offers a direct way to use the SHEETS function on Windows. Other products support related calculation workflows, but their primary use cases differ across spreadsheets, databases, and PDF forms.
Use Cases
| No. | Scenario | Suitable For | Main Need | How SHEETS Helps |
|---|---|---|---|---|
| 1 | Check how many worksheets a workbook contains | Finance, admin, and data organization users | A workbook has many tabs and manual counting is inefficient | Use SHEETS() to return the total number of worksheets in the current workbook |
| 2 | Confirm whether a reference covers multiple worksheets | Formula users | It is unclear whether a reference points to the intended worksheet scope | Enter a reference in the function and review the returned count |
| 3 | Learn function syntax before entering formulas | New spreadsheet users | The parameter format and entry method are not yet familiar | Review syntax and parameter guidance from Insert Function before confirming the formula |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Basic spreadsheet formula entry | ✅ | ✅ |
| SHEETS function usage | ✅ | ✅ |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More template benefits |
| Advanced PDF tools | Basic features | More advanced features |
| AI tools | Limited access for some features | More AI features and higher usage allowances |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Everyday spreadsheet editing and basic formula use | Free | The SHEETS function and standard spreadsheet editing are available directly |
| More cloud storage, templates, or broader office features | WPS Premium | Suitable for users who also need expanded document, PDF, and cloud capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page