SHEETS in WPS on Windows: Introduction

SHEETS in WPS is a worksheet-counting function in Sheets; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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

SHEETS in WPS on Windows is a spreadsheet function used to return the number of worksheets in a reference, or the total number of worksheets in the current workbook when no argument is provided.

Core capabilities include:

Show syntax guidance when you type =SHEETS( so you can complete the formula more easily.
Let you enter the function directly in a cell or in the formula bar and calculate with Enter.
Support cross-sheet references and nested formulas for multi-sheet spreadsheet work.
Update results as referenced content changes, which helps with ongoing worksheet checks.

This function is useful for workbook review, formula learning, and cross-sheet counting in spreadsheet work. It helps reduce manual counting and makes it easier to confirm how many worksheets are included in a workbook or reference.

System Requirements

Item	Requirement
OS	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 is needed for download, updates, or account sign-in
Other	You need to be able to open WPS spreadsheet files and edit formulas in cells

Download & Installation

Before using the SHEETS function, install WPS Office for Windows and open the Sheets component.

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office → open a spreadsheet file → select any cell and type `=SHEETS(`

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Sheets, you can enter the `SHEETS` function directly, view syntax guidance, use cross-sheet references, and get updated results as workbook content changes.	Excel provides `SHEETS(reference)` to return the number of sheets in a reference, and returns the total number of sheets in the workbook when the argument is omitted.	Google Sheets supports spreadsheet formulas and functions, and shows a function help box with definitions and syntax while you edit formulas.	Notion formulas work in database properties and can use functions, operators, and existing properties, but they are not designed for worksheet counting in a workbook.	Acrobat supports calculated PDF form fields such as sums and products in forms, but it is not a worksheet-function environment.
WPS Advantages	Advantage: It fits directly into the spreadsheet editing flow for workbook review, cross-sheet formulas, and quick worksheet counting in WPS Office.	Compared with WPS: Excel has a directly corresponding `SHEETS` function with similar syntax and behavior.	Compared with WPS: Google Sheets emphasizes general spreadsheet formulas and in-editor help, but the cited official pages focus on broad formula support rather than a dedicated `SHEETS` help page.	Compared with WPS: Notion formulas are centered on database properties instead of workbook sheet-counting tasks in spreadsheets.	Compared with WPS: Adobe calculation features are focused on PDF form fields rather than worksheet references in spreadsheet files.
Official Source	—	SHEETS function	Google Sheets function list	Intro to formulas	Configure form field calculations

Overall Conclusion
If your work centers on spreadsheet formulas and multi-sheet workbook checks, SHEETS in WPS is a practical fit for everyday spreadsheet tasks on Windows. Microsoft Excel offers a directly comparable function, while Google, Notion, and Adobe focus on broader formulas, database formulas, or PDF form calculations for different use cases.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Count worksheets in the current workbook	Finance staff, administrative staff	A workbook with many tabs is hard to count manually	Enter `=SHEETS()` in a cell to return the total number of worksheets in the current workbook
2	Count worksheets included in a reference	Data organizers	It is hard to confirm the coverage of a cross-sheet reference	Use `SHEETS(reference)` to check how many worksheets are included in the reference
3	Learn formula syntax	New users	Formula arguments are not yet familiar	Type `=SHEETS(` to view syntax guidance and complete the formula step by step
4	Verify results with other formulas	Advanced spreadsheet users	Multi-sheet work often needs dynamic checks	Combine SHEETS with other formulas so the result updates as data changes

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
SHEETS function entry and calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates and added benefits
Some advanced PDF and AI features	Limited	More advanced features and higher usage allowances

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Learning the SHEETS function and handling basic spreadsheet calculations	Free	Function entry, syntax guidance, and basic spreadsheet editing are enough for everyday use
Needing more cloud storage, templates, or broader office features	WPS Premium	A better fit for users who work with multiple document types and want expanded benefits

WPS membership center: Subscribe now