WPS Features
Resources
Free AI Tools
Docs Center

How to Use

Last updated:July 8, 2026

This guide includes 3 how-to topics for COUNTIFS, covering insertion from the Insert Function dialog, direct formula entry, and reviewing syntax and parameter details.

How-to Index

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

How-to Guide

1. Insert COUNTIFS from the Insert Function dialog

Entry: 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 COUNTIFS in the Insert Function dialog.
  4. Select the function and confirm.
  5. Enter each parameter in the Function Arguments dialog.
  6. Confirm to finish inserting the function.

Success Criteria

  • Interface result: The target cell now contains a COUNTIFS formula.
  • Next action available: You can continue editing parameters or copy the formula to other cells.

Tips While Using

  • Use the English function name COUNTIFS when searching.
  • Review all parameters before confirming to reduce repeated edits.

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 =COUNTIFS(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter guidance, type =COUNTIFS( and press F1 to open syntax help.

Success Criteria

  • Interface result: The cell shows the calculated result, and the formula bar keeps the COUNTIFS formula.
  • Next action available: You can continue adjusting criteria ranges, criteria values, or fill the formula across cells.

Tips While Using

  • Separate parameters with English commas.
  • If the result is not as expected, check whether the referenced ranges and criteria are consistent.

3. Review COUNTIFS syntax and parameter details

Entry: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter COUNTIFS in the search box.
  3. Select the function to review the syntax COUNTIFS(...).
  4. Click the help link for the function to open more detailed guidance.

Success Criteria

  • Interface result: You can see the COUNTIFS syntax structure and parameter details.
  • Next action available: You can return to the spreadsheet and continue entering or editing the formula.

Tips While Using

  • Opening detailed help may require an internet connection.
  • Confirm the function name first, then fill in parameters against the guidance.