DMIN in WPS on Windows: Introduction

DMIN in WPS on Windows helps you return the smallest value in a database range that matches specific 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 availability	No version limit	Available in WPS Spreadsheet on Windows

About This Feature

Overview

DMIN is a database function in WPS Spreadsheet on Windows. It is used to return the smallest numeric value in a field for records that meet specified criteria.

Key capabilities include:

Calculating a minimum value by condition for database-style worksheets.
Showing syntax prompts after you start entering the function.
Supporting cross-sheet references in formulas.
Working with nested formulas and automatic recalculation when data changes.

This function is useful for sales analysis, inventory review, score tracking, and conditional reporting.

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 calculation; downloading, installation, and account services require internet access
Other	You need to open WPS Spreadsheet and edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet and type `=DMIN(` in a cell to confirm that the syntax prompt appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Spreadsheet supports the `DMIN` function for returning the smallest value in records that match criteria. It also supports syntax prompts, cross-sheet references, nested formulas, and automatic recalculation.	Microsoft Excel provides `DMIN(database, field, criteria)` to return the smallest number in a field of records in a list or database that matches specified conditions.	The official Google Docs product page highlights document collaboration and does not describe a spreadsheet database function equivalent to `DMIN` on that page.	The Notion Help Center focuses on workspace databases, pages, and formulas, but does not describe a spreadsheet-style `DMIN` function on the referenced page.	The Adobe Acrobat product page focuses on PDF, forms, and document workflows rather than spreadsheet database functions such as `DMIN`.
WPS Advantages	Advantage: You can enter `=DMIN(` directly in WPS Spreadsheet to view syntax prompts and complete conditional minimum calculations in a spreadsheet workflow with cross-sheet references and recalculation.	Compared with WPS: Excel also offers the same function name and documented syntax for database calculations in spreadsheets.	Compared with WPS: The referenced Google page is centered on document collaboration instead of function-level spreadsheet guidance.	Compared with WPS: Notion is oriented more toward workspace databases and page organization than spreadsheet function entry.	Compared with WPS: Adobe is oriented more toward PDF and form processing than spreadsheet database calculations.
Official Source	—	DMIN function	Google Docs product page	Notion Help Center	Adobe Acrobat product page

Overall Conclusion
WPS and Microsoft Excel both fit spreadsheet-based conditional minimum calculations. If your work is centered on entering formulas directly in WPS Spreadsheet and using built-in syntax prompts for daily analysis, DMIN fits naturally into that workflow, while the referenced Google, Notion, and Adobe pages focus on collaboration, workspace organization, or PDF handling.

Use Cases

No.	Scenario	Suitable Users	Main Challenge	How DMIN Helps
1	Find the minimum value in filtered sales records	Sales teams, operations teams	You need the smallest amount among records that meet a condition	Use DMIN to return the minimum value in the target field
2	Review inventory data	Warehouse teams, purchasing teams	You need the lowest stock value for a product group	Set criteria and calculate with DMIN
3	Track scores by condition	Teachers, trainers	You need the lowest score under a specific condition	Use DMIN with a criteria range and field setting
4	Summarize data across sheets	Finance teams, analysts	You need cross-sheet references with updated results	Use DMIN with cross-sheet references and recalculation
5	Build combined formulas	Advanced spreadsheet users	One function alone is not enough for analysis	Combine DMIN with other formulas in nested calculations

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Use the DMIN function	✅	✅
View function syntax prompts	✅	✅
Cross-sheet formula calculation	✅	✅
Other premium account services	Depends on the account page	Includes more membership-related services

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Daily spreadsheet calculation and learning functions	Free	The DMIN function itself has no membership restriction
You also need more account-related services	WPS Premium	Suitable when you want additional membership services in one plan

WPS membership center: Subscribe now