WPS AGGREGATE is a spreadsheet aggregation function in WPS Spreadsheet; 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 How-to Index |
| Membership-related items | 0 | Matches the number of membership-related rows in the How-to Index |
About This Feature
Overview
AGGREGATE is a built-in function in WPS Spreadsheet for returning aggregate calculations from a list or database, with options to ignore hidden rows and error values.
Core tasks include:
- Insert AGGREGATE from the Insert Function dialog.
- Type
=AGGREGATE(...)directly in a cell or in the formula bar. - Review the syntax
AGGREGATE(function_num, options, ref1, [ref2], ...)and its arguments.
It is useful for summary calculations, ranges that contain errors, and worksheets where hidden rows may affect results.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory network connection is required for local formula entry and calculation; internet access is needed for online help or downloads |
| Other | An editable WPS Spreadsheet file and permission to edit cells |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Spreadsheet and confirm that the Formula tab includes the Insert Function entry |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Provides the AGGREGATE function for list or database calculations, with options to ignore hidden rows and error values. | Excel provides the AGGREGATE function in both reference and array forms, with options to ignore hidden rows, error values, and nested aggregates. | Google Sheets does not list AGGREGATE in its official function list. Similar scenarios can be handled with functions such as SUBTOTAL or SUM. | Notion formulas support functions such as sum, mean, median, min, and max, mainly for database properties rather than spreadsheet-style AGGREGATE formulas. | Adobe Acrobat Sign supports calculated fields that update values based on form input, but it does not provide a spreadsheet AGGREGATE function. |
| Official Source | — | AGGREGATE function | SUBTOTAL function | Formula syntax and functions | Add calculated fields to a form |
Advantage: AGGREGATE can be entered directly in a spreadsheet formula and is suitable for ranges that include hidden rows or errors.
Overall Conclusion
If your work centers on spreadsheet aggregation and you want one function that can control whether hidden rows or error values are ignored, WPS and Microsoft Excel are the closest matches. Google Sheets, Notion, and Adobe can cover part of the calculation workflow, but they do so through separate functions, database formulas, or form calculations.
Use Cases
| No. | Scenario | Suitable For | Main Need | How AGGREGATE Helps |
|---|---|---|---|---|
| 1 | Summarizing data that contains errors | Data cleanup staff | Error values affect ordinary summary results | Use AGGREGATE with an option that ignores error values |
| 2 | Calculating results from filtered or partially hidden data | Finance and operations staff | Hidden rows can affect the result you want to review | Use AGGREGATE with an option that ignores hidden rows |
| 3 | Inserting a complex function more quickly | Everyday office users | Manual entry can be error-prone when argument order is unfamiliar | Use Insert Function and the Function Arguments dialog |
| 4 | Learning the function syntax | New spreadsheet users | The meanings of function_num, options, and references are unclear | Review the syntax and help details in the function dialog |
| 5 | Reusing the same summary formula across cells | Worksheet maintainers | The same aggregation logic is needed in multiple cells | Enter AGGREGATE once, then fill or copy it to other cells |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Basic WPS Spreadsheet functions | ✅ | ✅ |
| Entering and calculating AGGREGATE | ✅ | ✅ |
| Basic spreadsheet editing | ✅ | ✅ |
| Some advanced PDF, AI, and template features | Depends on the product page | Usually includes broader access or fuller availability |
| Cloud storage | 1GB | 20GB |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| You mainly need AGGREGATE, SUM, MAX, and other common spreadsheet functions | Free | AGGREGATE itself is available without membership for everyday spreadsheet calculations |
| You also need more cloud storage or broader office features | WPS Premium | Suitable for users who need cross-device storage and additional office capabilities |
How to Subscribe
- WPS membership page: Subscribe to WPS Premium
Source: WPS Office pricing page