COUNTIFS in WPS on Windows: Introduction

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

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

COUNTIFS is a built-in function in WPS Spreadsheet on Windows for counting cells that meet multiple criteria. When you type COUNTIFS(, the formula bar shows syntax guidance to help you confirm the argument order and structure.

Core capabilities include:

Entering and running a COUNTIFS formula directly in a cell or the formula bar.
Viewing syntax guidance while typing the function.
Using cross-sheet references and nested calculations for more complex analysis.
Recalculating results automatically when source data changes, with manual recalculation available when needed.

Common use cases include sales analysis, attendance summaries, project filtering, and condition-based data review. COUNTIFS helps reduce manual filtering and repeated counting while improving accuracy in multi-condition statistics.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation
Other	You need access to editable WPS Spreadsheet files and permission to edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Spreadsheet, create or open a worksheet, and type `=COUNTIFS(` in a cell to confirm that syntax guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	COUNTIFS in WPS Spreadsheet supports multi-criteria counting, cross-sheet references, nested calculations, and recalculation after data changes.	Microsoft Word supports formulas and logical comparisons inside tables, but its formula workflow is designed for document tables rather than a full spreadsheet function environment.	Google Sheets provides online spreadsheets for formulas, analysis, and collaborative editing.	Notion formulas work with database properties, built-ins, and functions for calculated fields in databases.	Adobe Acrobat supports calculated PDF form fields for form-based numeric results.
WPS Advantages	Advantage: Better aligned with everyday spreadsheet-based multi-criteria counting. Distinct: Syntax guidance appears while entering the function, and the workflow supports cross-sheet references and nested calculations.	Compared with WPS: Word formulas are more limited to document-table calculations and are not centered on spreadsheet-style function entry.	Compared with WPS: Google Sheets emphasizes browser-based collaboration, while WPS fits a local desktop spreadsheet workflow.	Compared with WPS: Notion formulas are designed for database properties rather than direct cell-by-cell spreadsheet formulas.	Compared with WPS: Acrobat calculations focus on PDF form fields instead of general spreadsheet data analysis.
Official Source	—	Use a formula in a Word table	Google Sheets product page	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
COUNTIFS in WPS is well suited to multi-condition counting in a spreadsheet workflow. Compared with document-table formulas, database formulas, or PDF form calculations, it is more directly aligned with users who need condition-based counting inside worksheet cells.

Use Cases

No.	Scenario	Suitable Users	Main Need	How COUNTIFS Helps
1	Sales data analysis	Sales teams, operations teams	Count records by region and product at the same time	Use COUNTIFS with multiple criteria in one formula
2	Attendance summaries	HR teams, administrative staff	Count attendance by department and status	Combine multiple conditions in a worksheet formula
3	Project filtering	Project managers	Count tasks that match several labels or conditions	Use cross-sheet references for broader data ranges
4	Data review	Finance staff, analysts	Refresh counts after source data changes	Use automatic recalculation to keep results current
5	Formula learning	Students, trainees	Understand how function arguments are entered	Type `COUNTIFS(` to view syntax guidance while building the formula

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
COUNTIFS formula entry and calculation	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page
Template downloads	Limited	More advanced templates and related benefits

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday spreadsheet counting and formula learning	Free version	COUNTIFS itself is available directly for routine data work
More cloud storage or broader office benefits	WPS Premium	Suitable for users who also need expanded storage, templates, or additional office benefits

WPS membership page: Subscribe now