WPS Features
Resources
Free AI Tools
Docs Center

How to Use the SUMIF Function in WPS on Windows

Last updated:July 14, 2026

This how-to guide includes 3 topics for using SUMIF in WPS on Windows, covering insertion from the Insert Function dialog, direct formula entry, and syntax review; 3 are free and 0 are membership-related.

How-to Index

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

How-to Guide

1. Insert SUMIF from the Insert Function dialog

Entry: 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 SUMIF in the dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to insert the formula.

Success Criteria

  • The current cell contains a SUMIF formula.
  • The formula returns a calculation result after the parameters are entered.
  • You can continue editing the formula or copy it to other cells.

Tips While Using

  • Text conditions in criteria usually need double quotation marks.
  • If you want to sum a different column, enter sum_range correctly.
  • If the ranges do not match in size, the result may not match your expectation.

2. Type the formula directly in a cell

Entry: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =SUMIF(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to reuse the formula, drag the fill handle to copy it to other cells.

Success Criteria

  • The cell shows a calculated result instead of plain formula text.
  • When the cell is selected, the full SUMIF formula is visible in the formula bar.
  • Copied formulas continue to calculate based on cell references.

Tips While Using

  • Use English commas as parameter separators.
  • If the result does not calculate, check whether the cell is formatted as text.
  • When filling formulas across cells, pay attention to relative and absolute references.

3. Review the syntax and parameter details

Entry: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter SUMIF in the search box.
  3. Select the function and review the syntax SUMIF(range, criteria, [sum_range]).
  4. Check the parameter descriptions to confirm how to fill in the condition range, condition, and sum range.
  5. Open the related help information if you need more detail.

Success Criteria

  • You can see the standard SUMIF syntax structure.
  • You can distinguish the roles of range, criteria, and [sum_range].
  • You can use the parameter details to correct an existing formula.

Tips While Using

  • sum_range is optional. If you leave it out, the function sums range itself.
  • Pay attention to the format of text conditions, comparison operators, and wildcards.
  • When troubleshooting, first confirm that the condition range and sum range correspond correctly.