How to Use the PIVOTBY Function in WPS on Windows

Last updated:July 20, 2026

This guide includes 4 how-to topics for the PIVOTBY function, and all 4 are available without membership; use the index below to jump to the task you need.

How-to Index

No.TopicMembership Requirement
11. Enter the PIVOTBY functionFree
22. View syntax guidance and parameter detailsFree
33. Use cross-worksheet references and nested formulasFree
44. Check automatic recalculationFree

How-to Guide

1. Enter the PIVOTBY function

Entry point: Formulas tab → formula bar

  1. Open your spreadsheet and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell.
  3. Type PIVOTBY(.
  4. Prepare to enter the required parameters.

Success Criteria

  • Interface result: The cell enters formula editing mode.
  • What you can do next: You can continue entering parameters and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.

2. View syntax guidance and parameter details

Entry point: Formula bar → guidance appears after you type the function name

  1. In a cell, type =PIVOTBY(.
  2. Check the syntax guidance that appears.
  3. Review the parameter requirements and examples.
  4. Continue entering the formula based on the guidance.

Success Criteria

  • Interface result: A syntax guidance panel appears for the function.
  • What you can do next: You can continue completing the formula with the displayed guidance.

Tips While Using

  • Common mistake: Ignoring parameter order or separators can cause formula errors.

3. Use cross-worksheet references and nested formulas

Entry point: Formula bar

  1. In the target cell, type =PIVOTBY(.
  2. Reference cells or ranges from other worksheets as needed.
  3. Combine PIVOTBY with other formulas for nested calculations.
  4. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell displays a calculation result.
  • What you can do next: You can keep adjusting the reference range or nested structure.

Tips While Using

  • Common mistake: An incorrect reference range can affect the final result.
  • Environment note: The referenced worksheet data must be available.

4. Check automatic recalculation

Entry point: A cell that already shows a PIVOTBY result

  1. Complete a PIVOTBY formula and confirm that a result appears.
  2. Edit the data used by the formula.
  3. Watch the result cell.
  4. Confirm that the result updates automatically after the data changes.

Success Criteria

  • Interface result: The result cell shows an updated value.
  • What you can do next: You can continue adjusting source data and reviewing the changes.

Tips While Using

  • Common mistake: If the formula points to the wrong cells, the updated result may not match your expectation.