GROUPBY in WPS on Windows: Introduction

WPS GROUPBY is a spreadsheet function for grouped calculations and summaries; 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
Version scope	No version limit	Available in Smart Spreadsheet across supported versions

About This Feature

Overview

The GROUPBY function in WPS Smart Spreadsheet is used for grouped calculations and data analysis. After you enter the function, you can complete grouped summaries, cross-sheet references, nested calculations, and automatic recalculation when source data changes.

Core capabilities include:

Enter the GROUPBY function quickly for spreadsheet calculations.
Use parameters for different grouped summary scenarios.
Reference data across worksheets and combine GROUPBY with nested formulas.
Keep results updated when referenced data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	Smart Spreadsheet is supported across available versions; using the latest WPS Office build is recommended
Network	Local formula calculation does not require a constant internet connection; download, installation, and account services require network access
Other	You need to open a spreadsheet file and enter the Smart Spreadsheet editing interface

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, open Smart Spreadsheet, and type `=GROUPBY(` in a cell to confirm that function guidance appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In Smart Spreadsheet, you can type `GROUPBY(` directly and use parameter guidance, cross-sheet references, nested calculations, and automatic recalculation.	Excel provides the GROUPBY function to create a summary of data by grouping on one axis and aggregating associated values.	Google Sheets mainly uses pivot tables to group, sort, summarize, and filter data for spreadsheet analysis.	Notion databases can group items by property and combine groups with filters, sorts, and sub-groups for database organization.	Adobe Acrobat focuses on PDF and document workflows, and the official help content does not describe a spreadsheet GROUPBY-style formula workflow.
WPS Advantages	Advantage: WPS fits direct cell-formula entry for grouped calculations, with formula guidance plus support for cross-sheet references and nested formulas.	Compared with WPS: Excel also offers GROUPBY, but the official page focuses on grouping and aggregation results rather than in-cell guidance or cross-sheet workflow details.	Compared with WPS: Google emphasizes pivot-table grouping in the interface instead of a same-name worksheet function entered directly in a cell.	Compared with WPS: Notion is oriented toward grouped database views and workspace organization rather than spreadsheet formula entry.	Compared with WPS: Adobe centers on PDF and document tasks, not worksheet-cell GROUPBY formulas.
Official Source	—	GROUPBY function	Customize a pivot table	Views, filters, sorts & groups	Acrobat Desktop Help

Overall Conclusion
If your work centers on grouped calculations inside spreadsheet cells, WPS GROUPBY aligns well with direct formula entry and recalculation workflows. Microsoft Excel also provides a GROUPBY function, while Google Sheets and Notion focus more on pivot-table or database grouping views, and Adobe Acrobat focuses on document workflows instead of spreadsheet formulas.

Use Cases

No.	Scenario	Suitable Users	Main Pain Point	How GROUPBY Helps
1	Sales data summaries	Sales teams, operations teams	Need to summarize detailed records by category quickly	Use GROUPBY to group by fields and return summary results
2	Cross-sheet analysis	Finance teams, data coordinators	Data is spread across multiple worksheets and takes time to consolidate	Use cross-sheet references together with GROUPBY for unified calculations
3	Complex formula models	Advanced spreadsheet users	A single formula is not enough for the full analysis	Combine GROUPBY with nested formulas
4	Dynamic report updates	Report maintainers	Results need to stay aligned with changing source data	Use automatic recalculation to keep outputs updated

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
GROUPBY function usage	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Some advanced PDF, template, and extended benefits	Limited by plan scope	More benefits available depending on plan
Cloud storage	1 GB	20 GB in some plans

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday GROUPBY calculations and basic summaries	Free plan	The feature information shows no membership restriction for this function
Need more cloud storage or broader office benefits	WPS Premium	Suitable for users who also need additional value-added capabilities

WPS membership center: Subscribe now