How to Use the DPRODUCT Function in WPS on Windows

Last updated:July 20, 2026

Use DPRODUCT through 4 how-to topics, including entering the function, checking syntax prompts, working with cross-sheet references, and updating recalculated results; 4 items are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter the DPRODUCT functionFree
22. Check the function syntax promptFree
33. Use cross-sheet referencesFree
44. Update results with recalculationFree

How-to Guide

1. Enter the DPRODUCT function

Feature path: Formulas tab → Formula bar

  1. Open WPS Spreadsheet and select the cell where you want to show the result.
  2. Type = in the selected cell or in the formula bar.
  3. Enter DPRODUCT(.
  4. Fill in the database range, field, and criteria range as required.
  5. Press Enter to confirm and view the result.

Success Criteria

  • Interface result: the target cell shows a calculated result.
  • What you can do next: you can continue editing the formula or copy it to other cells.

Tips While Using

  • Common mistake: missing the = sign or leaving brackets unclosed can cause a formula error.
  • Environment note: make sure the referenced range contains data that can participate in calculation.

2. Check the function syntax prompt

Feature path: Formulas tab → Formula bar

  1. Select the target cell.
  2. Type =DPRODUCT(.
  3. Check the syntax prompt that appears.
  4. Fill in the parameters in order based on the prompt.

Success Criteria

  • Interface result: a parameter prompt appears after the function is entered.
  • What you can do next: you can continue completing the formula with the prompt.

Tips While Using

  • Common mistake: if the function name is misspelled, the correct prompt may not appear.

3. Use cross-sheet references

Feature path: Formulas tab → Formula bar

  1. Enter =DPRODUCT( in the result cell.
  2. Switch to the worksheet that contains the source data.
  3. Select the database range or enter the cross-sheet reference manually.
  4. Return to the formula and complete the field and criteria range.
  5. Press Enter to finish the calculation.

Success Criteria

  • Interface result: the formula includes worksheet reference information.
  • What you can do next: you can modify source-sheet data and observe result changes.

Tips While Using

  • Common mistake: an incomplete worksheet name or range reference can affect the result.

4. Update results with recalculation

Feature path: A result cell that already contains DPRODUCT

  1. Find the cell that already uses DPRODUCT.
  2. Modify relevant source data in the database range.
  3. Check whether the result cell updates automatically.
  4. If it does not update as expected, review whether the formula range is correct.

Success Criteria

  • Interface result: the result cell changes after the source data changes.
  • What you can do next: you can continue adjusting the criteria range and review the updated result.

Tips While Using

  • Common mistake: changing data outside the referenced formula range will not affect the current result.