COUNTIFS in WPS on Windows: Introduction

COUNTIFS in WPS is a multi-criteria counting function for WPS multidimensional tables; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limits	None stated	Available in WPS multidimensional tables

About This Feature

Overview

COUNTIFS in WPS is a commonly used formula function for multidimensional tables. It counts records that meet multiple conditions at the same time. You can use it in a formula field, combine it with other functions, and set different criteria through its parameters.

Core tasks include:

Insert COUNTIFS in a formula field for multi-criteria counting.
Set ranges and criteria with the function's parameter format.
Combine COUNTIFS with other functions in the same formula.

Common use cases include project tracking, status-based summaries, and categorized record analysis. It helps reduce manual filtering and keeps results updated as data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory network connection is required for local formula editing; internet access is needed for online help or account services
Other	You need access to a WPS multidimensional table and permission to edit fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a multidimensional table, and confirm that you can add a Formula field and enter COUNTIFS

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use COUNTIFS in a formula field inside a multidimensional table to count records that meet multiple conditions, and combine it with other functions.	Excel provides the COUNTIFS function to count cells or rows that meet multiple criteria across ranges.	Google Sheets provides COUNTIFS to return the count of a range based on multiple criteria.	Notion provides database formulas and property-based calculations, but not a spreadsheet-style COUNTIFS function over cell ranges.	Adobe Acrobat focuses on PDF form calculations and scripting rather than a native spreadsheet COUNTIFS function.
WPS Advantages	Advantage: COUNTIFS can be used directly in a multidimensional table formula field, and results refresh with record changes.	Compared with WPS: supports multi-criteria counting in spreadsheet worksheets.	Compared with WPS: supports multi-criteria counting in online spreadsheet ranges.	Compared with WPS: formula logic is centered on database properties instead of spreadsheet-style criteria ranges.	Compared with WPS: Acrobat is better aligned with PDF form calculations than spreadsheet record counting.
Official Source	—	Excel COUNTIFS function	Google Sheets COUNTIFS	Notion formula syntax and functions	Adobe advanced form fields

Overall Conclusion: If your work centers on counting records with multiple conditions in a multidimensional table, WPS COUNTIFS fits that workflow directly in a formula field. Excel and Google Sheets offer similar counting functions in spreadsheet grids, while Notion and Adobe are better suited to database-property logic or PDF form calculations.

Use Cases

No.	Scenario	Suitable For	Main Pain Point	How COUNTIFS Helps
1	Project status tracking	Project managers	Need to count records that match several status conditions	Use COUNTIFS in a formula field to count matching records
2	Sales data summaries	Operations and sales teams	Need fast counts based on multiple fields	Set multiple criteria and return the count automatically
3	Rule checking in tables	Data maintainers	Need to verify whether a category reaches a target count	Combine COUNTIFS with other functions for checks
4	Recurring report updates	Team leads	Manual recounting is inefficient after data changes	Let the formula field refresh results automatically
5	Category-based analysis	Admin and finance staff	Multi-category data is hard to summarize quickly	Count records by condition groups

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Use COUNTIFS in multidimensional tables	Available	Available
Core Writer, Spreadsheet, and Presentation apps	Available	Available
Some advanced PDF and extended services	May vary by feature	More advanced capabilities are available

Source: WPS Office pricing page; Why pay for WPS Office

Recommendations

Scenario	Recommended Plan	Why
You mainly need COUNTIFS and other basic formula features in multidimensional tables	Free	The source feature information shows no membership restriction for this function
You also need more advanced PDF tools, extended services, or broader office extras	WPS Premium	Better suited to users with ongoing needs beyond basic table formulas

WPS membership center: Subscribe now

Source: WPS Office pricing page