DPRODUCT in WPS Spreadsheet: Multiply a Field Across Matching Records
Use DPRODUCT 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: DPRODUCT multiplies the selected numeric field values across matching database records. With the complete worksheet below, =DPRODUCT(A1:D7,"Value",F1:F2) has independent expected result -3888.
Syntax and the three required arguments
=DPRODUCT(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 =DPRODUCT(A1:D7,"Value",F1:F2) in H2.
Group 1 selects 12, 18, −3 and 6. Multiply them in sequence: 12×18=216, 216×(−3)=−648, and −648×6=−3888. Group 2 selects 7 and 0, so its product is 0.
To check positional selection, replace "Value" with 3. 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: combine factors, not row-wise revenue
DPRODUCT reduces one selected field across records. It is appropriate when those entries are factors that should all be multiplied. It does not multiply two different columns row by row and then add their products. A sales table with Quantity and UnitPrice usually needs a separately defined revenue calculation rather than DPRODUCT over one column.
The sign of the worked result follows from one negative factor. If an additional selected record were assigned the same factor again, it would participate again; DPRODUCT does not deduplicate the selected values. Confirm that each record represents one intended factor.
For ID/104 criteria alone, the expected product is −3. For Group 2 it is zero because of the recorded zero factor. A zero result can hide the magnitudes of other selected factors; inspect the source rows before interpreting it. Products can also grow rapidly with record count, so distinguish numerical scale problems from criteria-selection mistakes.
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.
The worked Value field contains only numbers. Text, logical values, formula-empty strings and errors mixed into that field are outside the examples; no coercion or error-propagation rule is inferred for them.
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 DPRODUCT lesson was published 2019-05-15 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.