How to Use the DSUM Function in WPS on Windows

This section includes 3 how-to topics for DSUM, and all 3 are available without membership.

How-to Index

How-to Guide

1. Insert DSUM through the Insert Function dialog box

Entry path: Formulas tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for DSUM in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• Interface result: The target cell contains a DSUM formula.
• What you can do next: You can continue editing parameters, press Enter to confirm, or copy the formula to other cells.

Tips While Using

• You can search for the function name with uppercase or lowercase letters.
• Before entering parameters, make sure the database range, field, and criteria range are ready.

2. Type the DSUM formula directly in a cell

Entry path: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =DSUM(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review parameter guidance, type =DSUM( and press F1 to view syntax help.

Success Criteria

• Interface result: The cell shows a calculated result, and the formula bar keeps the DSUM formula.
• What you can do next: You can drag to fill, copy and paste, or continue adjusting referenced ranges.

Tips While Using

• Make sure the parameter separator matches your current spreadsheet environment.
• If the result is not correct, first check whether the field name matches the title in the criteria range.

3. Review DSUM syntax and parameter details

Entry path: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Type DSUM in the search box.
3. Select the function to review its syntax and parameter details.
4. Click the help link for more detailed information.

Success Criteria

• Interface result: You can see the DSUM syntax structure and parameter explanations.
• What you can do next: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

• When reviewing the parameters, focus on the relationship between the database range, the field argument, and the criteria range.
• Internet access is needed when opening the help link.