How to Use the SUMIFS Function in WPS on Windows

Last updated:July 23, 2026

This section includes 3 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps to complete the setup.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call SUMIFSFree
22. View and fill in the SUMIFS argument formatFree
33. Use an example to verify calculation resultsFree

How-to Guide

1. Create a formula field and call SUMIFS

Entry path: Add Field → Formula

  1. Open the target multidimensional table.
  2. Click Add Field on the toolbar.
  3. Select the Formula field type.
  4. Enter a formula that includes SUMIFS in the formula editor.
  5. Click Confirm to save.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can continue editing formula arguments and view the calculation result.

Tips While Using

  • Common mistake: If you choose a plain text or number field instead of a formula field, you cannot enter a function formula.
  • Environment note: You need edit permission for the current multidimensional table.

2. View and fill in the SUMIFS argument format

Entry path: Formula Editor → Function Library → SUMIFS

  1. Open the function library in the formula editor.
  2. Select SUMIFS to view its argument structure.
  3. Fill in the target data range in order.
  4. Continue with the criteria ranges and matching criteria.
  5. Check that parentheses, commas, and references are complete.

Success Criteria

  • Interface result: The full SUMIFS structure is shown in the formula editor.
  • Next action available: You can save the formula and move on to result verification.

Tips While Using

  • Common mistake: If the criteria ranges do not match the sum range, the result may be incorrect or return an error.
  • Common mistake: If text criteria and numeric criteria are entered in the wrong position, the total may be affected.

3. Use an example to verify calculation results

Entry path: Formula field result area

  1. Enter an example formula in the formula field.
  2. Save it and review the current record or related result.
  3. Change a condition value or target value in the source data.
  4. Check whether the formula result refreshes automatically.

Success Criteria

  • Interface result: The formula field displays a calculated result.
  • Next action available: After data changes, the result updates accordingly.

Tips While Using

  • Common mistake: If you enter only the target range without completing the criteria arguments, you will not get the expected multi-criteria result.
  • Environment note: If the source data types do not match, the result may be abnormal.