DMIN in WPS on Windows: Introduction

DMIN in WPS is a database function in Spreadsheet that returns the minimum value from a target 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

DMIN is a database function in WPS Spreadsheet for conditional calculation in structured data ranges. It is used to return the minimum numeric value from a specified field after records are filtered by a criteria range.

Core capabilities include:

Enter the =DMIN( function directly in a cell.
Fill in database, field, and criteria arguments with syntax guidance.
Use cross-sheet references when data is stored on different worksheets.
Update results after source data changes and recalculation is completed.

It fits scenarios such as sales analysis, inventory checks, and conditional reporting. It helps reduce repeated manual filtering and improves consistency in formula-based 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
Network	No mandatory network connection is required for local formula calculation; downloading, signing in, and cloud features require internet access
Other	You need permission to open Spreadsheet files and edit cells and formulas

Download & Installation

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

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, DMIN returns the minimum value from a field based on a database range, field, and criteria range, and supports cross-sheet references and recalculation.	Microsoft Word supports formulas inside table cells, including functions such as SUM, AVERAGE, and MIN, but this is designed for document tables rather than spreadsheet-style database analysis.	The official Google Docs page highlights Gemini features for drafting, summarizing, and asking questions, and does not describe an equivalent document-level database function like DMIN.	Notion formulas perform calculations with database properties, built-ins, and functions, which works well for property-based database logic.	Adobe Acrobat supports calculation rules for PDF form fields, which is useful for form workflows rather than worksheet-style database functions.
WPS Advantages	Advantage: DMIN is built for worksheet-based conditional database calculations. Distinct: it follows the standard spreadsheet formula workflow, so it fits naturally with other formulas.	Compared with WPS: Word formulas are more suitable for basic calculations in document tables and provide a narrower calculation context for structured data analysis.	Compared with WPS: the official page focuses on AI writing assistance instead of spreadsheet database functions comparable to DMIN.	Compared with WPS: Notion formulas depend on database properties and workspace structure, while WPS keeps a familiar spreadsheet formula entry model.	Compared with WPS: Acrobat calculations are centered on PDF form field behavior, not spreadsheet formula editing.
Official Source	—	Use a formula in a Word table	Gemini in Google Docs	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
If your main task is to return the minimum value from filtered worksheet data and continue working with spreadsheet formulas, DMIN in WPS is a closer fit for that workflow. The other products also provide calculation-related features, but they focus on document tables, workspace databases, or PDF forms.

Use Cases

No.	Scenario	Suitable for	Main challenge	How DMIN helps
1	Find the lowest sales value under conditions	Sales teams, operations teams	You need the minimum transaction value from records that meet specific conditions	Use DMIN with a criteria range to return the minimum value in the target field
2	Check the lowest inventory level	Warehouse teams, procurement teams	You need to identify the lowest stock value for a product group quickly	Set criteria in the inventory table and calculate with DMIN
3	Review categorized financial data	Finance teams, auditors	Manual checking after multi-condition filtering takes time	Use the database range and field argument to calculate automatically
4	Analyze data across worksheets	Data coordinators	Cross-sheet references can be hard to manage manually	Use cross-sheet references inside DMIN formulas

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic DMIN function usage	✅	✅
Core Office features	✅	✅
Advanced PDF and extended tools	Partially limited	More items available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday spreadsheet calculation and formula learning	Free	Basic DMIN usage has no membership restriction and is suitable for routine conditional calculations
More cloud storage and broader advanced tools	WPS Premium	Suitable if you also need more advanced features and cross-device work support

WPS membership center: Subscribe now