How to Use the SUBTOTAL Function in WPS on Windows

Use the SUBTOTAL function with 3 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps to complete the task.

How-to Index

How-to Guide

1. Enter SUBTOTAL from the Insert Function dialog box

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

Success Criteria

• Interface result: The target cell contains the SUBTOTAL function.
• You can continue: You can still edit the function_num value and reference ranges.

Tips While Using

• Common mistake: If you do not select the target cell first, the function may be inserted in the wrong location.
• Environment note: A WPS Spreadsheet file must already be open.

2. Type the formula directly in a cell

Entry path: Cell → Formula bar

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

Success Criteria

• Interface result: The cell shows a calculation result, and the formula bar keeps the full formula.
• You can continue: You can copy the formula to other cells.

Tips While Using

• Common mistake: Incorrect parentheses, commas, or parameter order can cause unexpected results.
• Environment note: The parameters must match the current data range.

3. Review function syntax and parameter details

Entry path: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter SUBTOTAL in the search box.
3. Select the function and review the syntax: SUBTOTAL(function_num, ref1, [ref2], ...).
4. Open the related help entry to review more parameter details.

Success Criteria

• Interface result: You can see the function name, syntax structure, and parameter input area.
• You can continue: You can continue inserting or editing the function based on the guidance.

Tips While Using

• Common mistake: Mixing up function_num with reference arguments can lead to unexpected results.