COUNTIFS in WPS on Windows: Introduction

COUNTIFS is a multi-criteria counting function in WPS Spreadsheets; 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 Spreadsheets on Windows for counting cells or records that meet multiple criteria.

Its main capabilities include:

Entering the COUNTIFS function quickly for multi-criteria counting.
Filling in arguments with syntax prompts for different calculation scenarios.
Supporting cross-worksheet references and nested calculations.
Updating results automatically when source data changes.

Common use cases include sales tracking, attendance summaries, inventory filtering, and conditional analysis.

It helps reduce manual filtering and repeated counting while improving accuracy in multi-condition statistics.

A practical advantage is that you can complete formula entry, prompting, and calculation directly inside the spreadsheet workflow.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local function calculation does not require a constant internet connection; downloading, installation, and account-related actions require network access
Other	You need to be able to open WPS spreadsheet files and edit cells and formulas

Download & Installation

Before using COUNTIFS, install WPS Office for Windows and open the spreadsheet component.

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a spreadsheet file, and confirm that you can enter COUNTIFS from the Formula tab or the formula bar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports COUNTIFS in spreadsheets for multi-criteria counting, including cross-worksheet references, nested calculations, and automatic recalculation.	Excel provides the COUNTIFS function to apply criteria across multiple ranges and count cells when all criteria are met, with up to 127 range and criteria pairs.	Google Sheets provides COUNTIFS to count values based on multiple criteria, and additional criteria ranges must have the same row and column size as the first criteria range.	Notion provides database formulas that use properties, built-ins, and functions for calculations, but it does not present COUNTIFS as a traditional spreadsheet function.	Acrobat mainly provides calculated PDF form fields such as sum, product, average, minimum, and maximum, rather than a spreadsheet-style multi-criteria counting function.
WPS Advantages	Advantage: COUNTIFS fits directly into the spreadsheet workflow in WPS, combining formula entry, syntax prompts, cross-sheet references, and automatic recalculation for routine analysis.	Compared with WPS: Excel also offers a mature COUNTIFS syntax and broad spreadsheet support for workbook-based analysis.	Compared with WPS: Google Sheets supports COUNTIFS, but the workflow is centered on the web spreadsheet environment.	Compared with WPS: Notion is more suitable for database property formulas and workspace organization than cell-based function counting.	Compared with WPS: Acrobat is more suitable for PDF form field calculations than spreadsheet data counting across multiple criteria.
Official Source	—	COUNTIFS function	COUNTIFS	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion: If your main task is multi-criteria counting in a Windows spreadsheet workflow, COUNTIFS in WPS is a practical fit for everyday editing and analysis. Microsoft Excel and Google Sheets provide comparable function support, while Notion and Adobe focus on database formulas or PDF form calculations for different scenarios.

Use Cases

No.	Scenario	Suitable Users	Core Need	Solution
1	Sales target counting	Sales teams, operations staff	Count records by region and month at the same time	Use COUNTIFS with multiple criteria
2	Attendance summary filtering	HR teams, administrative staff	Count attendance data by department and status	Combine multiple criteria ranges and conditions in one formula
3	Inventory condition analysis	Warehouse teams, procurement staff	Find how many items meet several conditions	Use COUNTIFS to count across inventory fields
4	Cross-sheet data checking	Finance teams, analysts	Keep counting logic consistent across worksheets	Use cross-worksheet references in COUNTIFS
5	Dynamic report updates	Managers, analysts	Avoid manual recounting after source data changes	Use automatic recalculation to keep results updated

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
COUNTIFS entry and calculation	✅	✅
Multi-criteria counting	✅	✅
Cross-worksheet references and nested calculations	✅	✅
Automatic recalculation	✅	✅
Extra PDF tools, more cloud storage, and broader office benefits	Limited or available within the free plan scope	More extended benefits are available

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday spreadsheet counting and formula learning	Free	COUNTIFS itself is available without membership
Users who also need more PDF tools, cloud storage, or broader office benefits	WPS Premium	A better fit when you use additional office features beyond spreadsheet formulas

WPS membership center: Subscribe now