SUBTOTAL in WPS on Windows FAQ

When using SUBTOTAL, common questions usually involve formula errors, parameter understanding, unexpected results, and recalculation checks; this FAQ covers 4 frequent questions.

FAQ

What should I do if the SUBTOTAL function shows an error?

1. Check whether the formula starts with =.
2. Check whether the parentheses, commas, and parameter count are complete.
3. Confirm that the referenced range is valid and typed correctly.
4. Press Enter again to run the calculation.

How can I view syntax guidance for SUBTOTAL?

1. Select the target cell.
2. Type =SUBTOTAL(.
3. Look at the formula editing area for syntax guidance.
4. Continue entering the function code and reference range based on the prompt.

Why is my SUBTOTAL result incorrect?

1. Check whether the selected range includes cells that should not be part of the calculation.
2. Check whether the parameters match your current summary goal.
3. Confirm that the referenced range does not create repeated counting.
4. Adjust the formula and review the result again.

Why does the result not change after I edit the data?

1. Confirm that you changed data inside the range actually referenced by the formula.
2. Select the result cell again to review the current reference range.
3. Edit the formula and update the reference range if needed.
4. Change the source data again and check whether the result updates.

Glossary