DPRODUCT in WPS on Windows FAQ

Last updated:July 20, 2026

When using DPRODUCT, the most common questions focus on formula errors, syntax prompts, unexpected results, and recalculation checks; this FAQ covers 4 common questions.

FAQ

What should I do if DPRODUCT shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether brackets, commas, and parameter counts are complete.
  3. Review the database range, field, and criteria range with the syntax prompt.
  4. Press Enter again after making corrections.

How can I view the DPRODUCT function guidance?

  1. Select the target cell.
  2. Type =DPRODUCT(.
  3. Review the syntax prompt that appears.
  4. Complete the parameters based on the prompt and test the result.

Why is the DPRODUCT result incorrect?

  1. Check whether the referenced range contains numbers stored as text.
  2. Check whether the criteria range headers match the database field names.
  3. Confirm that the field argument points to the column that should be multiplied.
  4. Review the result again after adjusting the data.

Why does the result not change after I edit the data?

  1. Check whether the edited data is inside the database range used by the formula.
  2. Check whether the criteria range still matches the current records.
  3. Select the formula cell again and confirm the referenced range.
  4. Re-enter the formula if needed and test the updated result.

Glossary

TermDefinition
DPRODUCTA database function that multiplies values in a specified field across records that meet defined criteria.
Database rangeThe worksheet range used in DPRODUCT, usually including field headers and multiple rows of records.
Criteria rangeThe range that defines which records are included in the calculation, usually with field names and matching conditions.
Cross-sheet referenceA reference in the current formula to a cell or range on another worksheet.