PIVOTBY in WPS on Windows FAQ

This FAQ focuses on 3 common question types for PIVOTBY, including input errors, help lookup, and result checking, plus 3 glossary terms.

FAQ

What should I do if the PIVOTBY function shows an error after I enter it?

1. Check whether the formula starts with =.
2. Check whether the parentheses are paired correctly and whether the separators are correct.
3. Review the syntax prompt to confirm that the parameter types and count match the function requirements.
4. Press Enter again after making corrections.

How do I view the PIVOTBY function description?

1. Select any editable cell.
2. Type =PIVOTBY(.
3. Review the syntax prompt that appears automatically.
4. Continue entering the formula based on the parameter notes and examples.

How to use the PIVOTBY function in WPS on Windows when the result does not look correct?

1. Check whether the referenced cells contain numbers stored as text.
2. Check whether there is a circular reference or an incorrect reference range.
3. Change the source data and review whether the result updates again.
4. If needed, recheck the nested functions and parameter order.

Glossary