SUMIFS in WPS on Windows: Introduction

SUMIFS in WPS is a multi-criteria sum function for multidimensional tables; 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 index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

SUMIFS is a formula function in WPS multidimensional tables that sums target data based on multiple criteria.

Its core capabilities include:

Using SUMIFS in a formula field for multi-condition calculations.
Filling in the target range and criteria ranges in the correct argument order to reduce formula errors.
Verifying results with an example and checking whether results refresh after data changes.

This feature is useful for sales summaries, project data rollups, and amount totals filtered by multiple conditions.

It helps when you need to evaluate several conditions in one formula and want results to update after source data changes.

A distinct benefit is that the function can be used directly in a formula field and combined with other functions.

System Requirements

Item	Requirement
Operating system	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 network connection is required for local formula editing; downloading, installation, and account-related actions require internet access
Other	You need access to a WPS workspace that contains a multidimensional table and permission to edit fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a multidimensional table, and confirm that you can add a Formula field

Source: WPS download center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use SUMIFS in a multidimensional table formula field to sum records that meet multiple conditions, and combine it with other functions.	Excel provides the SUMIFS function to add cells that meet multiple criteria, with support for multiple criteria range and criteria pairs.	Google Sheets provides the SUMIFS function to return a sum based on multiple criteria.	Notion provides database formulas with functions such as `ifs` and `sum`, but it is not the same as a spreadsheet-style SUMIFS function.	Adobe does not provide an equivalent spreadsheet SUMIFS help page in its main product help flow; its official references are mainly for form scripting and PDF workflows.
WPS Advantages	Advantage: You can complete multi-criteria totals directly in a multidimensional table formula field, and results refresh when records change.	Compared with WPS: Excel SUMIFS is designed for worksheet cell ranges in a traditional spreadsheet model.	Compared with WPS: Google Sheets also supports multi-criteria sums, but its official page notes that returning sums across multiple columns is not supported.	Compared with WPS: Notion focuses on database property calculations rather than a standard spreadsheet function workflow.	Compared with WPS: Adobe does not offer a same-component spreadsheet function workflow for this scenario.
Official Source	—	Excel SUMIFS function	Google Sheets SUMIFS function	Notion formula syntax	Adobe FormCalc Reference

Overall Conclusion
If your work is centered on record-based multidimensional tables, SUMIFS in WPS is a practical way to complete multi-criteria totals directly in a formula field. Excel and Google Sheets are closer to traditional worksheet-range calculations, while Notion and Adobe are not direct spreadsheet-function equivalents for this use case.

Use Cases

No.	Scenario	Suitable For	Core Need	How SUMIFS Helps
1	Sales amount summaries	Sales teams, operations teams	Need to total amounts by region and month at the same time	Use SUMIFS in a formula field with multiple conditions
2	Project expense rollups	Project managers, finance collaborators	Need to total expenses by project status and owner	Build the formula with criteria ranges and criteria values
3	Formula training demos	Trainers, internal support teams	Need to show formula syntax and result changes quickly	Use an example formula and observe automatic refresh
4	Post-import verification	Data coordinators	Need to confirm that totals update after imported data changes	Check whether the formula field result changes with source data
5	Combined formula calculations	Advanced users	Need to use a multi-criteria total inside another formula	Nest SUMIFS with other functions

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
SUMIFS function usage	✅ Available	✅ Available
Basic multidimensional table formula editing	✅ Available	✅ Available
Extended benefits such as advanced PDF tools and more cloud storage	Available within the free plan scope	Includes more advanced benefits and capacity

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Daily SUMIFS-based conditional totals	Free	The feature information shows no membership restriction for this function, so regular calculations can be completed directly
Need broader advanced office benefits at the same time	WPS Premium	Suitable if you also need expanded PDF tools, cloud storage, or other advanced capabilities

WPS membership center: Subscribe now