WPS Features
Resources
Free AI Tools
Docs Center

How to Use the SUMIFS Function in WPS on Windows

Last updated:July 13, 2026

Use the SUMIFS function in WPS Spreadsheet with 3 how-to topics, including 3 free topics and 0 membership-related topics, and choose the method that matches your worksheet task.

How-to Index

No.TopicMembership Requirement
11. Insert SUMIFS from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review the syntax and parameter descriptionFree

How-to Guide

1. Insert SUMIFS from the Insert Function dialog

Entry point: Formula 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 Formula tab.
  3. Search for SUMIFS in the dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog.
  6. Click OK to finish inserting the formula.

Success Criteria

  • The selected cell now contains a SUMIFS formula.
  • A calculation result appears after the parameters are entered.
  • The formula can be edited or copied to other cells.

Tips While Using

  • Keep the parameter order with the sum range first, followed by criteria range and criteria pairs.
  • When entering text criteria, make sure punctuation and symbols are correct.

2. Type the formula directly in a cell

Entry point: Worksheet cell or formula bar

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

Success Criteria

  • The cell shows a calculation result.
  • The full SUMIFS formula is visible in the formula bar.
  • The formula can be filled down or copied for repeated use.

Tips While Using

  • Separate parameters with English commas.
  • When copying the formula, check whether relative and absolute references are set as expected.

3. Review the syntax and parameter description

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter SUMIFS in the search box.
  3. Select the function and review the syntax: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...).
  4. Click the help link for more details if it is available in the dialog.

Success Criteria

  • You can see the standard SUMIFS syntax structure.
  • Required and optional parameters are easier to distinguish.
  • You can use the syntax to check whether an existing formula has parameter order issues.

Tips While Using

  • Multiple conditions should be entered as paired criteria ranges and criteria values.
  • If the result looks incorrect, first check whether the sum range and criteria ranges match correctly.