DMAX in WPS on Windows: Introduction

DMAX in WPS is a database function in WPS Spreadsheet that returns the maximum value in a specified field based on criteria; 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	All current tasks are available directly

About This Feature

Overview

DMAX is a built-in database function in WPS Spreadsheet for filtering table data by criteria and returning the maximum value from a target field. You can enter it through the Insert Function dialog, type the formula directly in a cell or the formula bar, or review its syntax and parameter details before using it.

Core tasks include:

Entering DMAX through the Insert Function dialog when you want guided parameter input.
Typing =DMAX(...) directly in a cell when you are comfortable with formula syntax.
Reviewing syntax and parameter descriptions before finalizing the formula.

This function is useful for sales records, inventory tables, score sheets, and other worksheets where you need the highest value that matches specific conditions.

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 internet connection is required for local formula entry; internet access is needed for online help or downloads
Other	WPS Spreadsheet should be installed, and the worksheet should include a data range and a criteria range

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a spreadsheet file, and confirm that the Insert Function entry is available on the Formulas tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the DMAX function in WPS Spreadsheet to return the maximum value in a database field that matches criteria, with support for dialog-based entry and direct formula input.	Excel provides the `DMAX(database, field, criteria)` function to return the largest number in a field of records that match specified conditions.	Google Sheets provides the `DMAX(database, field, criteria)` function to return the maximum value selected from a table-like range using criteria.	Notion formulas support `max()` and other formula functions for numbers and lists, but they are not structured as spreadsheet database functions with database, field, and criteria arguments.	Acrobat form calculations support predefined calculations such as Maximum for PDF form fields, which is aimed at form-field calculations rather than worksheet database analysis.
WPS Advantages	Advantage: WPS keeps the workflow inside a spreadsheet grid with criteria ranges, field references, and direct formula editing. Distinct: It supports both dialog-based entry and manual formula input for the same function workflow.	Compared with WPS: Excel offers a closely related DMAX workflow and similar syntax, so formula migration is straightforward.	Compared with WPS: Google Sheets also supports DMAX, but it is primarily used in a browser-based spreadsheet environment.	Compared with WPS: Notion is centered on database properties and formula fields, so it does not provide the same worksheet-style database function workflow.	Compared with WPS: Adobe focuses on PDF form calculations, so its maximum calculation scenario is different from spreadsheet data analysis.
Official Source	—	DMAX function	DMAX help	Formula syntax and functions	PDF form fields and calculated values

Overall Conclusion
If your main task is to return the highest value from spreadsheet data based on criteria, WPS, Microsoft Excel, and Google Sheets all provide a closely related database-function approach. WPS fits well for Windows users who want to enter formulas, review parameters, and calculate results directly in a spreadsheet workflow, while Notion and Adobe are better aligned with their own database-page or PDF-form scenarios.

Use Cases

No.	Scenario	Suitable for	Main challenge	How WPS helps
1	Finding the highest sales record by condition	Sales teams, operations teams	You need the highest sales amount for a specific region or product	Use DMAX with a criteria range to return the maximum value from the target field
2	Analyzing top scores in a grade sheet	Teachers, trainers	You need the highest score for a class or subject	Set up a criteria range in the score table and use DMAX
3	Reviewing inventory peaks	Warehouse teams, purchasing teams	You need the highest stock value for a product category	Use DMAX to calculate the maximum value in the inventory field
4	Checking the highest amount in financial records	Finance teams	You need the largest amount among records that meet a condition	Use the function arguments to define the database, field, and criteria
5	Reusing formulas in templates	General office users	You want to reuse conditional maximum calculations in existing sheets	Enter the function through Insert Function or type it directly

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic spreadsheet functions in WPS Spreadsheet	✅	✅
DMAX entry and calculation	✅	✅
More PDF tools, more templates, and more cloud storage	Some features are limited	More benefits are available

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet calculations and learning functions	Free	DMAX is part of a basic spreadsheet function workflow and can be used directly
Spreadsheet work plus broader PDF, template, or cloud needs	WPS Premium	Suitable when you also need more office-related benefits

WPS membership center: Subscribe now