DMAX in WPS on Windows: Introduction

DMAX in WPS is a database function in Spreadsheets that returns the maximum value in a specified field when records meet given 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
Version limits	None	Available in WPS Spreadsheets across supported versions

About This Feature

Overview

The DMAX function is a built-in database function in WPS Spreadsheets on Windows. It is used to return the maximum value from a target field in records that meet specified criteria. You can enter it directly in a cell or in the formula bar, and typing DMAX( displays syntax guidance, parameter details, and examples.

Core capabilities include:

Returning the maximum value from a database range based on conditions, which is useful for filtered statistics.
Supporting flexible parameters for different calculation and analysis scenarios.
Supporting cross-sheet references and nested formulas for more complex spreadsheet logic.
Recalculating automatically when source data changes, which helps keep analysis results up to date.

Common use cases include sales analysis, conditional statistics, report checking, and multi-sheet data analysis.

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; DMAX is available in WPS Spreadsheets
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account services
Other	You need permission to open spreadsheet files and edit cells or formulas

Download & Installation

Before using the DMAX function, install the Windows version of WPS Office and open WPS Spreadsheets.

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS → open Spreadsheets → select any cell and type `=DMAX(` to confirm that syntax guidance appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the DMAX function in WPS Spreadsheets to return the maximum value in a specified field based on criteria, with support for cross-sheet references, nested formulas, and automatic recalculation.	Excel provides `DMAX(database, field, criteria)` to return the largest number in a field of records in a list or database that matches specified conditions.	Google Sheets provides `DMAX(database, field, criteria)` to return the maximum value selected from a database table-like array or range using a SQL-like query.	Notion formulas support calculations based on database properties and functions, but they are not spreadsheet-style DMAX database functions.	Adobe Acrobat supports calculations, validation, and field summaries in PDF forms, but it does not provide a spreadsheet-style DMAX function.
WPS Advantages	Advantage: You can type `DMAX(` directly in WPS Spreadsheets and view syntax guidance while building the formula. Distinct: Cross-sheet references and automatic recalculation fit ongoing spreadsheet analysis workflows.	Compared with WPS: Excel offers the same function name and similar syntax for database-style spreadsheet calculations.	Compared with WPS: Google Sheets also supports DMAX, with an emphasis on web-based spreadsheet collaboration.	Compared with WPS: Notion is oriented toward database property formulas rather than cell-based spreadsheet database functions.	Compared with WPS: Adobe focuses on PDF form calculations instead of spreadsheet formula analysis.
Official Source	—	DMAX function	DMAX	Intro to formulas	Advanced form fields

Overall Conclusion: If your main task is finding the maximum value from spreadsheet records that meet conditions, WPS DMAX fits everyday spreadsheet analysis well. Microsoft Excel and Google Sheets provide closely related database functions, while Notion and Adobe focus on different calculation models.

Use Cases

No.	Scenario	Suitable for	Main challenge	How DMAX helps
1	Sales record analysis	Sales teams, operations teams	Need to find the maximum value from records that meet conditions	Use DMAX to return the maximum value from the target field
2	Multi-condition report checking	Finance teams, analysts	Manual filtering and comparison take time	Set criteria ranges and use DMAX for direct calculation
3	Cross-sheet data analysis	Heavy spreadsheet users	Data is spread across multiple worksheets	Combine DMAX with cross-sheet references
4	Dynamic dashboards	Managers, project members	Results need to stay updated when data changes	Use automatic recalculation to keep results current

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
DMAX formula entry and calculation	✅ Available	✅ Available
Basic spreadsheet formula features	✅ Available	✅ Available
Advanced PDF tools and additional value-added features	Partially limited	More advanced features available
Cloud storage and template-related benefits	Basic quota	Higher quota and more benefits

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet calculations and learning DMAX	Free	DMAX itself has no membership restriction
Broader PDF, cloud, or extended office needs	WPS Premium	Suitable when you also need more advanced office benefits

WPS membership center: Subscribe now