BYROW in WPS on Windows: Introduction

WPS BYROW is a row-based calculation function in 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
Version scope	No version limit	Available in Spreadsheets across supported versions

About This Feature

Overview

BYROW is a function in WPS Office for Windows Spreadsheets that processes data row by row in an array or range and returns a result for each row.

Core capabilities include:

Entering the BYROW function quickly for row-level calculations.
Using flexible parameters for different calculation and analysis scenarios.
Referencing other worksheets and combining nested formulas.
Updating results automatically when source data changes.

It is useful for row summaries, condition checks, batch row analysis, and combined formula workflows.

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; the feature is available in Spreadsheets across supported versions
Network	No mandatory internet connection is required for local formula editing
Other	You need permission to open and edit spreadsheet files

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, open Spreadsheets, select a cell, and type `=BYROW(` to confirm that formula input and syntax prompts are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In Spreadsheets, BYROW supports row-based calculation with syntax prompts, cross-worksheet references, nested formulas, and automatic recalculation.	Excel provides the BYROW function to apply a LAMBDA to each row and return an array of results.	Google Sheets provides BYROW to apply a LAMBDA to each row in an array or range, and each row must return a single value.	Notion formulas work on database properties and return results for records, rather than offering a spreadsheet-style BYROW array function.	Adobe Acrobat supports calculated fields in PDF forms for field-based calculations, rather than spreadsheet row-array functions.
WPS Advantages	Advantage: WPS supports direct row-based formula entry, cross-worksheet references, nested calculations, and automatic recalculation in a spreadsheet workflow.	Compared with WPS: Excel also supports row-based LAMBDA calculations and array results, with a stronger focus on formal function syntax.	Compared with WPS: Google Sheets also supports BYROW with LAMBDA, but each grouped row must resolve to a single value.	Compared with WPS: Notion is better suited to database property formulas than spreadsheet row-array analysis.	Compared with WPS: Adobe is better suited to PDF form calculations than spreadsheet formula analysis.
Official Source	—	BYROW function	BYROW function	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
BYROW is well suited to row-based spreadsheet calculations and analysis. For spreadsheet formula work, WPS is comparable to Microsoft Excel and Google Sheets, while Notion and Adobe focus on database or form-based calculation scenarios.

Use Cases

No.	Scenario	Suitable For	Main Need	How BYROW Helps
1	Row summary calculations	Data organizers	Summarizing multiple columns row by row	Use BYROW to calculate totals or statistics for each row
2	Conditional result checks	Finance and operations users	Evaluating row-level conditions	Combine BYROW with logical expressions to return row results
3	Cross-worksheet processing	Users working across multiple sheets	Handling data stored on different worksheets	Reference another worksheet and calculate row by row
4	Combined formula analysis	Advanced spreadsheet users	Building more complex logic than a single function can handle	Nest BYROW with other functions
5	Dynamic result updates	Report users	Keeping results aligned with changing source data	Use automatic recalculation to keep results current

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
BYROW function	Available	Available
Basic spreadsheet editing	Available	Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More template benefits
PDF and advanced tools	Basic features	More advanced tools

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday formula entry and basic data analysis	Free	BYROW itself is available for regular spreadsheet work
More cloud storage and broader office features	WPS Premium	Useful if you also need more templates, PDF tools, and extended office features

WPS membership center: Subscribe now