ROWS in WPS on Windows: Introduction

WPS ROWS is a lookup and reference function in Spreadsheets that returns the number of rows in a specified reference, array, or range; 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

The ROWS function in WPS Spreadsheets on Windows returns the number of rows in a specified reference, array, or range. It is useful for spreadsheet calculations, data analysis, and formulas that need row counts to update automatically.

Core capabilities include:

Enter ROWS( directly in a cell or the formula bar to start a calculation.
Return the row count for a selected reference, array, or range.
Work with cross-sheet references and nested formulas.
Update results automatically when referenced data changes.

Common use cases include data counting, formula building, and cross-sheet calculations.

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	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related actions
Other	You need to open WPS Spreadsheets and edit formulas in worksheet cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, create or open a spreadsheet, and type `=ROWS(` in a cell to confirm the formula input environment is available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the ROWS function in WPS Spreadsheets to return the number of rows in a reference, array, or range, with support for cross-sheet references and nested formulas.	Excel provides the ROWS function and returns the number of rows in a reference or array with the syntax `ROWS(array)`.	Google Sheets provides the ROWS function and returns the number of rows in a specified array or range.	Notion does not provide a same-name ROWS spreadsheet function, but its formula system supports `length()` for counting items in text or list values.	Adobe Acrobat focuses on PDF accessibility, forms, and document structure tools rather than spreadsheet range functions such as ROWS.
WPS Advantages	Advantage: WPS offers a spreadsheet formula workflow with direct formula-bar entry, syntax prompts, cross-sheet references, and nested calculation support in one worksheet environment.	Compared with WPS: Excel offers a closely aligned ROWS function, so spreadsheet users can move between similar formula patterns.	Compared with WPS: Google Sheets also supports ROWS, but it is centered more on browser-based collaboration workflows.	Compared with WPS: Notion formulas are designed for database properties and lists instead of cell-range formulas in a spreadsheet grid.	Compared with WPS: Acrobat supports PDF checking and form-related tasks, but it does not provide a spreadsheet function environment for row-count formulas.
Official Source	—	ROWS function	ROWS	Formula syntax and functions	Create and verify PDF accessibility

Overall Conclusion
For spreadsheet users who need row counts, cross-sheet references, and standard formula workflows, WPS is closer to Microsoft Excel and Google Sheets. Notion is more suitable for database-property formulas, while Adobe Acrobat is designed for PDF workflows rather than spreadsheet calculations.

Use Cases

No.	Scenario	Suitable for	Main pain point	How ROWS helps
1	Count rows in a data range	Spreadsheet editors	Manual counting takes time	Enter `ROWS(range)` to return the row count directly
2	Count rows across worksheets	Finance and operations users	Data is spread across multiple sheets	Use a cross-sheet reference as the function argument
3	Build nested formulas	Data analysts	A single function is not enough for more complex logic	Combine ROWS with other functions in one formula
4	Keep results updated after edits	Daily office users	Added or deleted rows can change totals	Let automatic recalculation keep the result in sync
5	Learn formula syntax and troubleshooting	New users	Formula arguments can be hard to understand at first	Use syntax prompts in the formula bar while entering ROWS

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic use of the ROWS function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF, templates, and broader office benefits	Some features are limited	More advanced benefits and extended tools are available
Cloud storage	1 GB	20 GB, based on the current pricing page

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Daily spreadsheet work with ROWS and other basic functions	Free plan	It covers standard formula entry, calculation, and viewing needs
Work that also needs more cloud storage, PDF tools, and broader office features	WPS Premium	It is more suitable for users with broader cross-scenario office needs

Subscribe here: Get WPS Premium