How to Use the COUNTIFS Function in WPS on Windows

Last updated:July 17, 2026

Use COUNTIFS through 4 how-to topics, all available without membership, and jump from the index to the matching steps below.

How-to Index

No.TopicMembership Requirement
11. Enter the COUNTIFS functionFree
22. Fill in arguments with syntax promptsFree
33. Use cross-worksheet references and nested calculationsFree
44. Check automatic recalculation resultsFree

How-to Guide

1. Enter the COUNTIFS function

Entry point: Open WPS Spreadsheets → Formula tab → formula bar or target cell

  1. Open the spreadsheet and select the cell where you want to show the result.
  2. Type = in the formula bar or directly in the cell.
  3. Type COUNTIFS(.
  4. Check the syntax prompt that appears and get ready to enter the arguments.

Success Criteria

  • Interface result: =COUNTIFS( appears in the cell or formula bar.
  • Next action available: You can continue entering criteria ranges and criteria.

Tips While Using

  • Common mistake: If you do not start with =, the entry may not be recognized as a formula.
  • Environment note: You need to work in an editable spreadsheet cell.

2. Fill in arguments with syntax prompts

Entry point: The formula bar while COUNTIFS is being entered

  1. Enter the first criteria range.
  2. Enter the matching criterion.
  3. Continue entering additional criteria ranges and criteria in order.
  4. Check that parentheses, separators, and argument order are correct.
  5. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell shows a counting result instead of staying in edit mode.
  • Next action available: You can select the result cell and review the full formula.

Tips While Using

  • Common mistake: Unmatched parentheses or missing separators can cause formula errors.
  • Environment note: Different data types may require different criterion formats.

3. Use cross-worksheet references and nested calculations

Entry point: A target cell that is already in formula editing mode

  1. Switch to another worksheet while editing the COUNTIFS arguments.
  2. Select the needed criteria range to create a cross-worksheet reference.
  3. If needed, add another function or expression for nested calculation.
  4. Confirm the references and argument logic, then submit the formula.

Success Criteria

  • Interface result: The formula contains another worksheet reference or a nested expression.
  • Next action available: You can change source data and observe result updates.

Tips While Using

  • Common mistake: If the referenced range and criteria do not match, the result may be inaccurate.
  • Environment note: The referenced worksheets need to remain available in the current file.

4. Check automatic recalculation results

Entry point: A result cell that already contains a COUNTIFS formula

  1. Edit the source data in the counted range.
  2. Check whether the result cell updates automatically.
  3. If the result does not change, review the referenced ranges and criteria settings.
  4. Confirm the formula again and test once more if needed.

Success Criteria

  • Interface result: The result cell updates when the source data changes.
  • Next action available: You can copy the formula or extend it to other counting areas.

Tips While Using

  • Common mistake: If the wrong range is referenced, recalculation may still return an unexpected result.
  • Environment note: If the workbook uses a special calculation setting, check the current calculation status first.