SUBTOTAL in WPS on Windows: Introduction

SUBTOTAL in WPS on Windows is a spreadsheet subtotal function for data calculation and analysis; it 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

The SUBTOTAL function in WPS Spreadsheet helps you summarize and analyze data ranges in a worksheet. When you type the function, WPS shows syntax guidance so you can confirm the parameter structure while editing.

Core tasks include:

Enter the SUBTOTAL function for routine worksheet calculations.
Fill in parameters with on-screen syntax guidance.
Reference data from other worksheets in the same workbook.
Check recalculation after source values change.

This function fits common scenarios such as sales summaries, expense tracking, and filtered data review. It helps reduce repeated manual calculations and keeps results aligned with source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related services
Other	You need to open or create a WPS Spreadsheet file and have permission to edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a spreadsheet, type `=SUBTOTAL(` in a cell, and confirm that formula input and syntax guidance appear

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports entering the `SUBTOTAL` function in a spreadsheet for data summaries, parameter input, cross-worksheet references, and recalculated results after data changes.	Excel provides `SUBTOTAL(function_num, ref1, [ref2], ...)` and documents how different function numbers include or ignore hidden rows.	Google Sheets provides `SUBTOTAL(function_code, range1, [range2, ...])` for vertical ranges and notes that filtered-out cells are excluded.	Notion provides database formulas with properties, operators, and functions, but it does not present a spreadsheet `SUBTOTAL` function workflow.	Adobe Acrobat supports calculated form fields and totals in PDF forms, which is a different workflow from spreadsheet function editing.
WPS Advantages	Advantage: WPS keeps SUBTOTAL entry inside the spreadsheet editing flow with formula-bar input and syntax guidance for routine worksheet work.	Compared with WPS: Excel documents more detail about function-number behavior for hidden rows, while the use case remains spreadsheet subtotal calculation.	Compared with WPS: Google Sheets also supports SUBTOTAL and highlights filtered-range analysis; WPS is closer to a desktop spreadsheet editing flow on Windows.	Compared with WPS: Notion formulas are designed for database properties rather than cell-based spreadsheet subtotal entry.	Compared with WPS: Adobe focuses on PDF form calculations instead of worksheet subtotal editing.
Official Source	—	SUBTOTAL function	SUBTOTAL function	Formula syntax & functions	Advanced form fields

Overall Conclusion: For everyday subtotal and summary work in spreadsheets on Windows, WPS provides a direct worksheet-based editing flow for SUBTOTAL. Microsoft Excel and Google Sheets offer comparable function support, while Notion and Adobe focus on database formulas or PDF form calculations instead of the same spreadsheet scenario.

Use Cases

No.	Scenario	Suitable for	Main pain point	How SUBTOTAL helps
1	Sales data summaries	Sales teams and operations staff	Need to total worksheet ranges quickly	Enter SUBTOTAL in the target cell to calculate a summary
2	Reviewing filtered results	Data analysts	Need a summary view after filtering data	Use SUBTOTAL with the selected data range
3	Referencing multiple worksheets	Finance and admin teams	Data is split across worksheets	Reference another worksheet range in the formula
4	Updating recurring reports	Spreadsheet maintainers	Results need to stay current after source edits	Let the formula recalculate when data changes

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic spreadsheet functions	✅	✅
Routine SUBTOTAL calculations	✅	✅
Basic document editing and saving	✅	✅
Additional advanced value-added features	Available within the free scope shown on the product page	More advanced features are available based on the subscription plan

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday spreadsheet summaries and learning formulas	Free	Basic SUBTOTAL use is available without membership and fits routine summary work
Broader office work with more advanced features	WPS Premium	Suitable if you need more than basic spreadsheet functions

WPS membership center: Subscribe to WPS Premium