COUNTA in WPS on Windows: Introduction

COUNTA in WPS is a formula for counting non-empty values in a specified range in 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
Recommended version	Latest WPS Office for Windows	Helps ensure a stable formula editing experience

About This Feature

Overview

COUNTA is a commonly used formula function in WPS Office on Windows for counting the number of non-empty cells or values in a specified range. You can use it in a formula field, enter the target range with the required syntax, and combine it with other functions for more flexible data analysis in WPS spreadsheets and multidimensional tables.

Core capabilities include:

Use COUNTA in a formula field to count non-empty values quickly.
Enter ranges with the required function syntax for basic counting.
Combine COUNTA with functions such as IF and AND for more complex table logic.

It is useful for data entry checks, completeness reviews, and record counting.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest WPS Office version is recommended
Network	An internet connection is recommended for installation and sign-in; local editing can continue after installation
Other	Access to the multidimensional table and permission to edit formula fields

Download & Installation

Before using COUNTA, install WPS Office on your Windows device and open the relevant multidimensional table or spreadsheet workspace.

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

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use COUNTA in a formula field in a multidimensional table to count non-empty values in a specified range and combine it with other functions.	Excel provides the COUNTA function to count non-empty cells in a range.	Google Sheets provides the COUNTA function to return the number of values in a dataset and supports multiple values or ranges.	Notion tables support column calculations such as Count not empty, and its formula system supports general functions, but it does not provide a spreadsheet COUNTA function with the same workflow.	Adobe Acrobat Sign supports calculated fields that update form results dynamically based on entered values, but this is for PDF forms rather than spreadsheet formulas.
WPS Advantages	Advantage: COUNTA can be used directly in a formula field inside a multidimensional table; Distinct: it fits table-field workflows where results update with data changes.	Compared with WPS: Excel focuses on traditional spreadsheet cell counting.	Compared with WPS: Google Sheets offers a similar counting function for online spreadsheet workflows.	Compared with WPS: Notion is centered on database property calculations instead of cell-based spreadsheet formulas.	Compared with WPS: Adobe focuses on PDF form calculations and signing workflows rather than spreadsheet function workflows.
Official Source	—	COUNTA function in Excel	COUNTA in Google Sheets	Table view in Notion / Formula syntax in Notion	Calculated fields in Adobe Acrobat Sign

Overall Conclusion
COUNTA in WPS works well for non-empty value counting and routine data checks in multidimensional tables. If your work depends on formula fields connected to table data, WPS offers a workflow that stays close to that table-based setup, while the alternatives focus more on classic spreadsheets, database properties, or PDF forms.

Use Cases

No.	Scenario	Suitable for	Main challenge	How COUNTA helps
1	Count completed records	Data entry staff	Need to know how many rows already contain valid content	Use COUNTA in a formula field to count non-empty values
2	Review imported data completeness	Operations and analysts	Hard to check missing values after import	Use COUNTA to review whether a target range is filled
3	Build logic-based rules	Table builders	A single count is not enough for business rules	Combine COUNTA with IF and AND
4	Show dynamic results	Team collaborators	Results need to refresh when data changes	Save the formula field and let the result update automatically
5	Reuse table templates	Project managers	Rebuilding counting logic repeatedly takes time	Preset a COUNTA formula field in a reusable template

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic COUNTA usage	✅ Available	✅ Available
Basic spreadsheet and formula editing	✅ Available	✅ Available
More advanced office and PDF benefits	Some features are limited	More advanced features and extended benefits are available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily counting and routine spreadsheet work	Free	It covers basic COUNTA usage and standard formula editing
Need more advanced office features and larger cloud storage	WPS Premium	It is more suitable when you also need broader office tools and expanded storage

Membership page: Subscribe to WPS Premium