DCOUNTA in WPS Spreadsheet: Count Populated Fields in Matching Records
Use DCOUNTA in WPS Spreadsheet with a complete database and criteria grid, field-name and position examples, and documentation-based limitations.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: DCOUNTA counts nonempty cells in a selected field among records that meet the criteria. With the complete worksheet below, =DCOUNTA(A1:D7,"Note",F1:F2) has independent expected result 3.
Syntax and the three required arguments
=DCOUNTA(database,field,criteria)
- database: a rectangular list including its header row. Each following row is a record; each column is a field.
- field: the header text in quotes, or the field’s one-based position within the database. In A1:D7, Value is field 3 and Note is field 4. These positions are relative to the database, not an arbitrary worksheet column number.
- criteria: a separate range containing at least one field header and a condition directly below it. Pass the range including its header, rather than the condition cell alone.
The official lesson permits both field names and positions. Names are easier to read; positional formulas must be revisited when the database’s column order changes. Keep header spelling consistent between the database and the criteria block.
Complete worksheet example
Create a fresh worksheet and enter this database in A1:D7. Leave D3 genuinely empty; the word “blank” in this table is an instruction, not text to enter. Enter the zero in D7 as a number.
| Row | A: ID | B: Group | C: Value | D: Note |
|---|---|---|---|---|
| 1 | ID | Group | Value | Note |
| 2 | 101 | 1 | 12 | Ready |
| 3 | 102 | 1 | 18 | (leave empty) |
| 4 | 103 | 2 | 7 | Review |
| 5 | 104 | 1 | −3 | Hold |
| 6 | 105 | 2 | 0 | Ready |
| 7 | 106 | 1 | 6 | 0 |
Put Group in F1 and numeric 1 in F2. Keep this criteria block outside the database. Enter =DCOUNTA(A1:D7,"Note",F1:F2) in H2.
The selected Note cells are Ready, an actual blank, Hold and numeric 0. Three are populated, so the expected result is 3. Zero counts because it occupies a cell; it is not an empty value. Changing the criterion to Group 2 selects Review and Ready, giving 2.
To check positional selection, replace "Note" with 4. The expected result for the same criterion is unchanged. Use absolute references such as $A$1:$D$7 when copying a formula should preserve the database range, and check whether the criteria reference should remain fixed or move to another block.
Advanced use: count completed annotations
Use DCOUNTA on the Note field to count records with an annotation in Group 1. The count is three, while there are four matching records in the database. This can support a completion check, provided your definition of completion really is “cell is nonempty.” A numeric zero is counted, so this rule does not prove a meaningful written annotation exists.
For a narrower check, put Group in F1, ID in G1, 1 in F2 and 106 in G2. =DCOUNTA(A1:D7,"Note",F1:G2) is expected to return 1: the record meets both conditions and its Note is numeric zero. The official walkthrough demonstrates simultaneous conditions in one criteria row. It does not establish every possible multi-row criteria pattern here.
Do not substitute DCOUNT when text annotations should count. Numeric-only counting asks a different question. Similarly, using the Value field would count populated values in that field, not assess whether Notes have been completed.
Errors, empty selections and criteria limits
The cited lesson does not specify a complete error table or the result for a selection with no matching records. This guide therefore does not assign an empty-selection default or an invented error code. Before using such an outcome in a production rule, verify it in the intended WPS edition.
An actual empty cell is different from text, numeric zero, a space character or a formula returning an empty string. The examples establish actual blank versus populated values; formula-empty-string, Boolean and error-value counting are not resolved by the cited lesson.
Numeric equality criteria are used deliberately. Wildcards, text prefix matching, case sensitivity, multiple criteria rows, blank criteria and calculated-condition formulas need their own product-specific evidence. Do not generalize these small examples into an unrestricted filtering-language specification. Keep the criteria range exact: accidentally including additional rows changes the expression you are asking WPS to evaluate.
Evidence, availability and compatibility
The official WPS Academy DCOUNTA lesson was published 2019-05-31 and reviewed on October 18, 2026. It explicitly identifies WPS Office for Windows Personal, with no numeric build. The publication date is evidence of documentation by that date, not the first release. Introduction and last-supported versions remain unknown. The source does not identify this function as deprecated or retired.
These are original documentation-based examples with independent record selection and arithmetic. They were not executed in WPS. No screenshot or cross-edition execution is claimed. Check separators, localized entry and workbook interchange in the intended client before relying on them; file-format round trips were not tested.