PIVOTBY in WPS on Windows: Introduction

PIVOTBY in WPS on Windows is a spreadsheet function for data calculation and analysis; 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 limits	None	Available in Smart Spreadsheet across versions

About This Feature

Overview

PIVOTBY is a function in WPS Office for Windows that supports data calculation and analysis in spreadsheets. After you enter the function, you can complete different calculation scenarios with flexible parameters, cross-worksheet references, nested formulas, and automatic recalculation when source data changes.

Core capabilities include:

Enter PIVOTBY( to display syntax guidance for parameters and examples.
Use flexible parameters for different spreadsheet calculation tasks.
Reference cells across worksheets and combine the function with nested formulas.
Update results automatically after referenced data changes.

This function is useful for spreadsheet analysis, cross-sheet calculations, formula combinations, and routine data work in WPS Office.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App version	It is recommended to use the latest version of WPS Office; this function is available in Smart Spreadsheet across versions
Network	No mandatory internet connection is required for local formula entry and calculation
Other	You need permission to open spreadsheet files and edit cells and formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install WPS Office for Windows, then open a spreadsheet to use the PIVOTBY function
Post-install check	Open WPS Spreadsheet, select any cell, and enter `=PIVOTBY(` to confirm that syntax guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	PIVOTBY supports data calculation and analysis with flexible parameters, cross-worksheet references, nested formulas, and automatic recalculation after data changes.	Excel provides PivotTables to calculate, summarize, and analyze worksheet data, with field placement, refresh options, and summary methods.	Google Sheets supports formulas for calculations and can summarize data with charts and pivot tables.	Notion formulas perform calculations by using database properties, built-ins, and functions inside database workflows.	Adobe Acrobat form fields can be configured for calculations such as products and sums inside PDF forms.
WPS Advantages	Advantage: You can start directly in a worksheet cell by typing the function and viewing syntax guidance, while also combining cross-worksheet references and nested formulas in one spreadsheet workflow.	Compared with WPS: Microsoft emphasizes PivotTable-based analysis and summary workflows rather than a matching PIVOTBY function entered directly in a cell.	Compared with WPS: Google Sheets supports formulas and pivot-table summaries, but the official page focuses on general spreadsheet analysis and collaboration instead of a matching PIVOTBY function.	Compared with WPS: Notion formulas are designed for database properties rather than traditional spreadsheet cell formulas.	Compared with WPS: Adobe calculation features are designed for PDF form fields rather than spreadsheet formula analysis.
Official Source	—	Create a PivotTable to analyze worksheet data	Google Sheets training and help	Intro to formulas	Advanced form fields

Overall Conclusion: If you want to calculate and analyze data directly in spreadsheet cells on Windows, PIVOTBY in WPS fits that workflow well. Other products also support analysis or calculations, but their official materials focus more on PivotTables, collaborative database formulas, or PDF form calculations.

Use Cases

No.	Scenario	Suitable For	Core Need	How PIVOTBY Helps
1	Routine data calculations	Office users	Need to calculate and analyze data quickly in cells	Enter PIVOTBY and complete the formula with syntax guidance
2	Cross-sheet analysis	Finance and operations users	Data is spread across multiple worksheets	Use cross-worksheet references in one formula
3	Combined formula workflows	Advanced spreadsheet users	One formula alone may not cover a more complex task	Nest PIVOTBY with other formulas
4	Dynamic result updates	Users who maintain changing data	Results need to update after source values change	Use automatic recalculation after edits
5	Formula learning and checking	New spreadsheet users	Need help understanding parameters and structure	Review syntax guidance and examples while typing

Membership & Benefits

Free vs WPS Premium

Feature	Free Users	WPS Premium
PIVOTBY function use	Available	Available
Basic PDF features	Available	Available
Templates and cloud storage	Limited	More benefits and higher storage capacity
Some advanced tools and value-added features	Depends on the feature	Broader access

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You mainly need PIVOTBY for routine spreadsheet calculations	Free	The function itself is available without membership
You also need more templates, cloud storage, or additional office benefits	WPS Premium	Better suited to broader office needs

WPS membership center: Subscribe now