WPS Statistics Fields on Windows: Introduction

WPS Statistics Fields is a smart spreadsheet field type for summarizing related records; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limit	None stated	No version gate is described for this feature

About This Feature

Overview

Statistics Fields is a field type in WPS smart spreadsheets that summarizes data from related records through linked fields. It supports count, sum, average, maximum, minimum, distinct values, distinct count, and string concatenation, which makes it useful for project progress summaries, work-hour totals, expense rollups, and other spreadsheet aggregation tasks.

Core tasks include:

Create a statistics field: Add a new statistics field from the add-field entry on the right side of the header row.
Configure statistics field settings: Choose the source field, calculation method, and conditions for the aggregation.

System Requirements

Item	Requirement
Operating system	A Windows PC that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	An internet connection is recommended when opening online smart spreadsheets or syncing data
Other	You need an editable data table, and it is recommended to create linked fields before configuring a statistics field

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a smart spreadsheet data table, and confirm that the Statistics field type appears in the add-field menu

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Statistics Fields can summarize related records through linked fields. It supports count, sum, average, maximum, minimum, distinct values, distinct count, string concatenation, and conditional aggregation.	Excel can aggregate one or more columns from a related table in Power Query, including functions such as Sum and Average.	Google Sheets can quickly show Sum, Average, Count, Minimum, and Maximum for selected cells, with more emphasis on single-sheet range summaries.	Notion rollups can aggregate properties from related databases, including Sum, Average, Count, Min, Max, and other calculations.	Acrobat can merge completed form data into a spreadsheet, which helps summarize form responses, but it is not a native relational spreadsheet field.
WPS Advantages	Advantage: WPS keeps related-record aggregation and condition setup at the field level inside the same data table. Distinct: It combines multiple aggregation methods with field settings for ongoing business data management.	Compared with WPS: Excel aggregation is available, but the official example focuses on Power Query processing rather than a field-level setup inside a live business table.	Compared with WPS: Google Sheets highlights quick calculations on selected cells, while official guidance here shows less emphasis on linked-record aggregation.	Compared with WPS: Notion also supports relation-based aggregation, but it is centered on database properties rather than a spreadsheet-style table field workflow.	Compared with WPS: Acrobat focuses on collecting completed form data into a spreadsheet and does not provide a native statistics field for related table records.
Official Source	—	Aggregate data from a column in Excel	See sum and average in Google Sheets	Relations and rollups in Notion	Work with form data in Acrobat

Overall Conclusion
WPS Statistics Fields is well suited to teams that need to keep related summaries inside the same working data table. For ongoing project, hour, or expense tracking, its field-level setup makes spreadsheet aggregation easier to maintain over time.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Project progress summary	Project managers and team leads	It is hard to review overall progress when many related tasks are spread across records	Use a statistics field to count related task records or apply conditional counts
2	Work-hour totals	Operations and delivery teams	Time records are scattered and manual rollups take time	Use a statistics field to sum or average linked hour fields
3	Expense rollups	Finance and admin teams	Distributed reimbursement or purchase records are easy to total incorrectly	Use a statistics field to sum amount fields and apply conditions when needed
4	Distinct-value analysis	Data administrators	Repeated values make it hard to see how many different items are present	Use distinct values or distinct count to review repeated and non-repeated entries
5	Text aggregation	Collaboration teams	Notes from related records are scattered across entries	Use string concatenation to combine related text content

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Statistics Fields basic use	✅ No membership limit is stated for this feature	✅
Basic PDF and office tools	✅ Available	✅
More cloud storage and advanced templates	Limited	More benefits available
Some AI and advanced tools	Limited or quota-based	More benefits available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You only need to create and configure Statistics Fields in smart spreadsheets	Free	This feature is described without a membership limit, so the main setup can be completed directly
You also need more cloud storage, templates, or advanced tools	WPS Premium	This is suitable when your work goes beyond statistics fields and needs broader office benefits

WPS membership center: Subscribe now