How to Use the GROUPBY Function in WPS on Windows

This how-to guide includes 3 operation topics, all available without membership; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Insert GROUPBY from the Insert Function dialog box

Entry path: Formulas tab → Insert Function, or the fx button in the formula bar

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 GROUPBY in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• Interface result: The target cell contains the GROUPBY function.
• What you can do next: You can continue editing parameters, confirm the result, or copy the formula.

Tips While Using

• Common mistake: A misspelled function name can make the function harder to find.
• Environment note: Keep internet access available if you want to open online help.

2. Type a GROUPBY formula directly in a cell

Entry path: A worksheet cell or the formula bar

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

Success Criteria

• Interface result: The cell shows the entered GROUPBY formula or the calculated result.
• What you can do next: You can keep editing the formula, drag to fill, or copy it to other cells.

Tips While Using

• Common mistake: Using full-width punctuation between parameters may cause the formula to fail.
• Environment note: Keyboard shortcuts work when the spreadsheet window is active.

3. Review GROUPBY syntax and parameter details

Entry path: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter GROUPBY in the search box.
3. Select the function to review its syntax and parameter details.
4. Click the help link for the function if you want more detailed information.

Success Criteria

• Interface result: You can see the GROUPBY function name, syntax, or parameter area.
• What you can do next: You can continue filling in parameters and insert the function.

Tips While Using

• Common mistake: If the wrong function is selected, the displayed description will not match GROUPBY.
• Environment note: Opening a help link usually requires internet access.