DMAX in WPS on Windows: Introduction

DMAX in WPS is a database function in Spreadsheets that returns the maximum value in a specified field based on criteria; 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

About This Feature

Overview

DMAX is a spreadsheet function in WPS that helps you return the largest value from a database range that matches specific criteria. When you type =DMAX(, WPS can show syntax guidance so you can continue entering the formula.

Core tasks include:

Enter the DMAX function for routine spreadsheet calculations.
Review syntax guidance and parameter requirements while editing.
Fill in references and criteria for conditional calculations.
Recalculate results after data changes during ongoing analysis.

Common use cases include sales filtering, inventory analysis, and conditional reporting. It helps reduce manual filtering and repeated calculations when you need the highest value that matches a condition.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula editing
Other	You need to open WPS Spreadsheets and edit formulas in cells

Download & Installation

Before using DMAX, install WPS Office for Windows and make sure you can open spreadsheet files.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, launch Spreadsheets, and confirm that you can type formulas in a cell

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports entering `DMAX(database, field, criteria)` in WPS Spreadsheets and showing syntax guidance during formula editing.	Excel provides the DMAX function and returns the largest number in a field of records that match specified conditions.	Google Sheets provides DMAX and returns the maximum value selected from a database table-like array or range using a SQL-like query.	Notion formulas support functions such as `max()` and property-based calculations, but not a spreadsheet-style DMAX database function structure.	Acrobat supports automatic calculations for PDF form fields such as sums and averages, but not a worksheet-style DMAX database function.
WPS Advantages	Advantage: DMAX fits directly into the spreadsheet formula workflow in WPS, with syntax guidance shown while you enter parameters.	Compared with WPS: Excel offers a closely matched DMAX function with the same database, field, and criteria pattern.	Compared with WPS: Google Sheets also supports DMAX, with documentation centered on table-like ranges and SQL-like query criteria.	Compared with WPS: Notion is oriented toward database properties and page-level formulas rather than cell-based spreadsheet database functions.	Compared with WPS: Acrobat calculations are designed for PDF form fields instead of spreadsheet database analysis.
Official Source	—	DMAX function	DMAX	Formula syntax and functions	Configure form field calculations in Acrobat

Overall Conclusion: WPS DMAX is a practical fit for spreadsheet users who need conditional maximum-value calculations on Windows. Microsoft Excel and Google Sheets are the closest alternatives for this workflow, while Notion and Adobe Acrobat focus on different calculation models.

Use Cases

No.	Scenario	Suitable For	Main Need	How DMAX Helps
1	Find the highest sales result under conditions	Sales teams, operations staff	Need the top value from filtered records	Use DMAX to return the maximum value in the target field
2	Review scores or performance data	Teachers, managers	Manual filtering takes too much time	Enter DMAX to calculate results directly in the sheet
3	Analyze inventory or purchasing records	Warehouse and purchasing teams	Hard to locate peak values within conditions	Combine field and criteria ranges for targeted analysis
4	Maintain recurring reports	General office users	Results need updating after data changes	Let the formula recalculate as the worksheet changes

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Enter DMAX and run basic calculations	✅	✅
Spreadsheet formula editing	✅	✅
Additional advanced office and PDF tools	Some features are limited	More features available
Cloud storage and added benefits	Basic quota	Higher quota and more benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Learning formulas and handling routine spreadsheet analysis	Free	DMAX and standard formula editing are already available
Using broader office and added-value tools in daily work	WPS Premium	Better suited when you also need more advanced tools and extra benefits

WPS membership center: Subscribe now