MAXIFS in WPS on Windows: Introduction

WPS MAXIFS is a conditional maximum function in WPS 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

The MAXIFS function in WPS helps you return the maximum value from a target range after applying one or more conditions in a multidimensional table formula field. It can be used together with other functions, and saved results update automatically when table data changes.

Core tasks include:

Create a formula field and enter a MAXIFS formula for conditional maximum calculations.
Fill in the target range and criteria arguments with the required syntax.
Apply a sample MAXIFS formula and verify that results refresh after data updates.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office and access multidimensional table features
App version	The latest version of WPS Office is recommended
Network	An internet connection is needed when opening online tables, loading function details, or syncing data
Other	You need permission to create or edit formula fields in a multidimensional table

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, enter a multidimensional table, and confirm that you can add a Formula field

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use MAXIFS in a multidimensional table formula field to return the maximum value that matches specified conditions, with support for formula combinations.	Excel provides the MAXIFS function to return the largest value that meets one or more criteria.	Google Sheets provides MAXIFS to return the maximum value in a range filtered by multiple criteria.	Notion provides database formulas and functions such as `max()`, but it does not provide a spreadsheet-style MAXIFS function with the same name.	Adobe Acrobat focuses on PDF form field calculations rather than spreadsheet functions equivalent to MAXIFS.
WPS Advantages	Advantage: MAXIFS can be added directly in a multidimensional table formula field and saved as part of the table structure. Distinct: results refresh automatically when source data changes.	Compared with WPS: Excel also supports conditional maximum calculations, but the workflow is centered on worksheet cell ranges.	Compared with WPS: Sheets also supports MAXIFS and requires the target range and criteria ranges to be the same size.	Compared with WPS: Notion is oriented more toward database property formulas and does not offer the same spreadsheet function entry point.	Compared with WPS: Adobe calculation features are designed for PDF forms, not multidimensional table formulas.
Official Source	—	Excel MAXIFS function	Google Sheets MAXIFS	Notion formula syntax	Acrobat form field calculations

Overall Conclusion
If your work centers on conditional maximum calculations inside online multidimensional tables, WPS MAXIFS fits directly into a formula-field workflow. Excel and Google Sheets offer closer spreadsheet equivalents, while Notion and Adobe focus more on database formulas or PDF form calculations.

Use Cases

No.	Scenario	Suitable for	Main challenge	How MAXIFS helps
1	Finding the highest value in filtered sales records	Sales teams, operations teams	You need the highest result from records that meet specific conditions	Use MAXIFS in a formula field to return the maximum matching value
2	Tracking peak metrics in project dashboards	Project managers, analysts	You need the highest metric by status or category	Use MAXIFS with criteria ranges to filter and calculate results
3	Refreshing results after imported data changes	Data maintenance teams	Manual recalculation takes time after data updates	Save the formula and let results update with table data

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
MAXIFS function usage	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Advanced PDF editing and more templates	Partially limited	✅ More advanced capabilities available
Cloud storage	1 GB	20 GB, with plan details shown on the pricing page
AI tools	Some limits apply	More usage and broader feature access

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly use MAXIFS and other basic formula functions in multidimensional tables	Free plan	MAXIFS is available without membership, which works well for everyday formula tasks
You also need more PDF tools, templates, cloud storage, or AI features	WPS Premium	A better fit for broader office workflows beyond basic formula use

WPS membership page: Subscribe now