COUNTA in WPS on Windows: Introduction

WPS COUNTA is a spreadsheet function for counting non-empty values; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	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

COUNTA is a built-in function in WPS Spreadsheet that counts non-empty cells and values in selected arguments or ranges. It is useful for data entry checks, worksheet summaries, and basic spreadsheet analysis.

Core capabilities include:

Entering the COUNTA formula in a cell or in the formula bar
Following syntax prompts to complete arguments more accurately
Supporting cross-sheet references and nested calculations
Updating results automatically when source data changes

Common use cases include counting completed records, checking whether a column has been filled in, and summarizing non-empty items quickly.

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 formula calculation does not require a constant internet connection; downloading, installation, and account services do require network access
Other	You need to open WPS Spreadsheet files and have permission to edit cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, launch Spreadsheet, and type `=COUNTA(` in a cell to confirm that function prompts appear

Source: WPS download center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the COUNTA function in WPS Spreadsheet to count non-empty values, with syntax prompts, cross-sheet references, and nested calculation support.	Excel provides the COUNTA function to count cells that are not empty in a range, and its documentation explains syntax, arguments, and related count functions.	Google Sheets provides COUNTA to return the number of values in a dataset, including text, zero-length strings, and whitespace.	Notion does not provide a spreadsheet COUNTA function, but database formulas and table calculations can count filled values, related items, or list lengths.	Adobe Acrobat Sign focuses on form fields and validation rules rather than spreadsheet-style COUNTA calculations.
WPS Advantages	Advantage: Uses a familiar spreadsheet formula workflow for non-empty counts, with syntax prompts and automatic recalculation in worksheet-based analysis.	Compared with WPS: Excel offers a similar COUNTA workflow and broader official guidance around related count functions.	Compared with WPS: Google Sheets also supports COUNTA, but it is centered on browser-based collaboration and online sheets.	Compared with WPS: Notion counting depends on database properties, formulas, or calculations instead of direct cell formula entry.	Compared with WPS: Adobe tools are designed for document forms and validation, not worksheet counting formulas.
Official Source	—	COUNTA function	COUNTA	Intro to formulas	Form field validations

Overall Conclusion
If your main task is counting non-empty values in a worksheet, WPS provides a direct spreadsheet formula experience that fits everyday data work on Windows. Microsoft Excel and Google Sheets offer closely related COUNTA behavior, while Notion and Adobe are oriented toward database logic or form workflows instead of standard worksheet formulas.

Use Cases

No.	Scenario	Suitable for	Main challenge	How COUNTA helps
1	Count completed records	Admin, sales, operations teams	Need to know quickly how many rows contain valid entries	Use COUNTA to total non-empty cells in a target column
2	Check data entry completeness	Data entry staff	Hard to confirm whether required fields have been filled in	Compare COUNTA results with the expected number of records
3	Summarize multiple ranges	Finance and analysts	Manual counting across separate ranges takes time	Count several arguments or ranges in one formula
4	Count across worksheets	Project teams	Data is split across different sheets	Add cross-sheet references inside COUNTA
5	Combine with other formulas	Advanced spreadsheet users	A single count is not enough for analysis	Nest COUNTA with other spreadsheet functions

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Enter and calculate the COUNTA function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF tools and additional value-added features	Partially limited	Broader access
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday spreadsheet counting and basic formula work	Free	COUNTA itself is available without membership for regular non-empty counting tasks
Need more cloud storage or broader office features beyond spreadsheets	WPS Premium	Better fit when your work also depends on expanded storage or additional premium tools

WPS membership: Subscribe now