How to Use the SORTBY Function in WPS on Windows

This how-to guide includes 3 topics for using SORTBY, covering Insert Function, direct formula entry, and syntax review; choose a topic from the index and follow the steps to complete it.

How-to Index

How-to Guide

1. Enter SORTBY through the Insert Function dialog

Entry path: Formulas tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for SORTBY in the Insert Function dialog.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog.
6. Click OK to finish entering the function.

Success Criteria

• Interface result: The target cell now contains a SORTBY formula.
• What you can do next: You can continue editing parameters, press Enter to confirm, or review the returned result area.

Tips While Using

• Common mistake: Extra spaces in the function name can make the search result harder to find.
• Environment note: You need to work in an editable worksheet.

2. Type a SORTBY formula directly in a cell

Entry path: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =SORTBY(...) directly in the cell or in the formula bar.
3. Press Enter to confirm the formula.
4. If you want to review the syntax, type =SORTBY( and press F1 to check the prompt.

Success Criteria

• Interface result: The cell shows the formula result, or the full formula is visible in the formula bar.
• What you can do next: You can continue adjusting the referenced range, sort key, or sort order.

Tips While Using

• Common mistake: An incorrect argument separator can cause the formula to fail.
• Environment note: The referenced range and the sorting array should stay aligned so the result is correct.

3. Review SORTBY syntax and parameter details

Entry path: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Type SORTBY in the search box.
3. Select the function to review its syntax and parameter area.
4. Open the related help entry if you want more detailed guidance.

Success Criteria

• Interface result: The SORTBY function description or parameter panel is open.
• What you can do next: You can fill in parameters based on the guidance and complete the formula.

Tips While Using

• Common mistake: Checking only the function name without confirming parameter order can lead to unexpected results.
• Environment note: The way help content is displayed may vary slightly by interface version.