How to Use the COUNTIFS Function in WPS on Windows

Last updated:July 23, 2026

This section includes 3 how-to topics, and all 3 are available without membership so you can jump to the task you need from the index.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call COUNTIFSFree
22. Set the COUNTIFS parameter formatFree
33. Combine COUNTIFS with other functionsFree

How-to Guide

1. Create a formula field and call COUNTIFS

Entry path: Add Field → Formula

  1. Open the multidimensional table that you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes COUNTIFS in the formula editor.
  5. Click Confirm and check whether the result appears in the formula field.

Success Criteria

  • On-screen result: A new formula field appears and shows a calculated result.
  • Next action: You can continue editing the formula or review updated results after records change.

Tips While Using

  • Common mistake: If you do not choose the Formula field type, you cannot enter a function formula.
  • Environment note: You need edit permission for the current multidimensional table.

2. Set the COUNTIFS parameter format

Entry path: Formula Editor → Function Library → COUNTIFS

  1. Open COUNTIFS in the formula editor.
  2. Fill in the parameters in order.
  3. Enter the target data range in the correct position.
  4. Set a matching condition for each range.
  5. Check the parameter order and parentheses, then save the formula.

Success Criteria

  • On-screen result: The formula saves successfully without a parameter format error.
  • Next action: You can add more criteria or revise existing ones.

Tips While Using

  • Common mistake: Incorrect parameter order or missing parentheses can cause formula errors.
  • Environment note: The criteria ranges and conditions should match your actual data.

3. Combine COUNTIFS with other functions

Entry path: Formula Editor

  1. Enter COUNTIFS in an existing formula field.
  2. Use COUNTIFS as an argument in another function, or combine it with other functions as needed.
  3. Check the references in the combined formula.
  4. Save the formula and review whether the result updates as expected.
  5. Modify source data and confirm that the result refreshes automatically.

Success Criteria

  • On-screen result: The combined formula saves successfully and returns a result.
  • Next action: When records change, the result updates accordingly.

Tips While Using

  • Common mistake: In nested formulas, it is easy to miss a parenthesis or reference target.
  • Environment note: It is helpful to verify a simple condition first, then expand to a combined formula.