How to Use the SUBTOTAL Function in WPS on Windows

Use SUBTOTAL through 4 how-to topics covering function entry, parameter input, cross-worksheet references, and recalculation checks; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Enter the SUBTOTAL function

Entry point: Open a WPS Spreadsheet file, select the target cell, and type in the cell or formula bar.

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to start formula entry.
3. Type SUBTOTAL(.
4. Confirm that the function is now in parameter-entry mode.

Success Criteria

• Interface result: The target cell or formula bar shows =SUBTOTAL(.
• What you can do next: You can continue entering the function code and reference range.

Tips While Using

• Common mistake: If you do not start with =, the content may be treated as plain text.
• Environment note: You need to work in an editable spreadsheet cell.

2. Fill in parameters with syntax guidance

Entry point: Continue editing in a cell where SUBTOTAL( has already been entered.

1. Enter the function code after the opening parenthesis.
2. Type a comma, then select or enter the cell range to calculate.
3. Add more ranges if your calculation needs them.
4. Type the closing parenthesis and press Enter.

Success Criteria

• Interface result: The cell returns a calculated result instead of an unfinished formula.
• What you can do next: You can select the cell again to review or edit the formula.

Tips While Using

• Common mistake: Missing parentheses or incomplete separators can cause a formula error.
• Environment note: The parameters should match your calculation goal.

3. Reference another worksheet in the formula

Entry point: Switch to the worksheet that contains the source data while editing the formula.

1. In the result cell, type =SUBTOTAL( and complete the earlier parameters you need first.
2. Switch to another worksheet that contains the source data.
3. Select the cell or range to insert that reference into the formula.
4. Confirm the formula and press Enter to calculate.

Success Criteria

• Interface result: The formula now includes a reference to another worksheet.
• What you can do next: If the referenced range changes, the result can update accordingly.

Tips While Using

• Common mistake: If the range is not selected correctly after switching worksheets, the reference may be incomplete.
• Environment note: The referenced worksheet must be in the current workbook and accessible.

4. Check automatic recalculation

Entry point: Edit source data in a worksheet that already contains a SUBTOTAL formula.

1. Find the data range used by the SUBTOTAL formula.
2. Change one or more values in that range.
3. Check whether the result cell updates with the data change.
4. Repeat the check with another edit if needed.

Success Criteria

• Interface result: The value in the result cell changes after the source data changes.
• What you can do next: You can keep editing, save the file, or adjust the formula range.

Tips While Using

• Common mistake: If you edit a cell outside the referenced range, the result will not change.
• Environment note: Recalculation behavior may differ if workbook calculation settings have been changed.