DCOUNTA in WPS on Windows: Introduction

DCOUNTA in WPS is a database counting function in Spreadsheets; 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

DCOUNTA is a database function in WPS Spreadsheets that counts non-empty cells in records that match specified criteria. It is useful for structured data analysis, conditional counting, and summary calculations in worksheet-based databases.

Core capabilities include:

Entering the DCOUNTA function quickly and completing the calculation.
Counting non-empty records by database range, field, and criteria range.
Supporting cross-sheet references and nested calculations.
Updating results automatically when source data changes.

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	Local formula calculation does not require a constant internet connection; downloading, installation, and account services do require network access
Other	You need permission to open and edit spreadsheet files and enter formulas in cells

Source: System requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, open a spreadsheet file, and confirm that the Formula tab and formula bar are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports DCOUNTA in WPS Spreadsheets for counting non-empty records that meet criteria, with cross-sheet references and nested calculations.	Excel provides the DCOUNTA(database, field, criteria) function to count nonblank cells in records that match specified conditions, and the field argument can be optional.	Google Sheets provides DCOUNTA(database, field, criteria) to count values, including text, from a database-style array or range using criteria.	Notion provides database formulas that can calculate values from properties and lists, including count-style results such as `length()`, but it does not provide a spreadsheet-style DCOUNTA database function.	Adobe Acrobat supports calculations in PDF form fields, but it does not provide a spreadsheet database function equivalent to DCOUNTA.
WPS Advantages	Advantage: Uses a spreadsheet database-function workflow directly in cells, which fits conditional counting, cross-sheet references, and automatic recalculation in worksheet analysis.	Compared with WPS: Offers a closely matched spreadsheet database-function workflow with similar syntax.	Compared with WPS: Offers a closely matched database-function workflow and emphasizes array or range queries in Sheets.	Compared with WPS: Focuses on database-property formulas rather than cell-based spreadsheet database functions.	Compared with WPS: Focuses on PDF form calculations rather than worksheet database counting.
Official Source	—	Excel DCOUNTA function	Google Sheets DCOUNTA	Notion formulas	Acrobat form field calculations

Overall Conclusion
DCOUNTA is well suited to worksheet-based conditional counting of non-empty records. Excel and Google Sheets provide closely matched database functions, while Notion and Adobe focus on database-property or PDF form scenarios instead of spreadsheet database functions.

Use Cases

No.	Scenario	Suitable for	Main need	How DCOUNTA helps
1	Counting filtered sales records	Sales teams, operations staff	Count valid records that meet specific conditions	Use DCOUNTA with a criteria range to count non-empty matching records
2	Multi-field data analysis	Data coordinators	Summarize records by field and condition combinations	Use database, field, and criteria arguments together
3	Cross-sheet counting	Finance teams, project staff	Count data stored across different worksheets	Use cross-sheet references inside the formula
4	Dynamic report updates	Report maintainers	Avoid manual recounting after data changes	Let the formula update results automatically

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Entering and calculating DCOUNTA	✅ Available	✅ Available
Basic spreadsheet formula features	✅ Available	✅ Available
Advanced PDF tools and broader add-on benefits	Limited	More benefits available
Cloud storage and template resources	Basic allocation	Higher allocation and more resources

Source: WPS Office pricing page

Recommendations

Use case	Recommended plan	Why
Everyday spreadsheet calculations and basic function use	Free	DCOUNTA itself is available without membership and works well for routine spreadsheet tasks
Broader office needs such as more cloud storage, templates, or extra tools	WPS Premium	Better suited when you need more bundled office benefits beyond basic formulas

WPS membership center: Subscribe to WPS Premium