When using the SUBTOTAL function, the most common questions focus on errors, unexpected results, and filling formulas across cells; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if the SUBTOTAL function shows a #VALUE! error?
- Check whether the parameter data types are correct and make sure the numeric range does not contain incompatible text values.
- Check whether the parentheses, commas, and parameter order in the formula are complete.
- If the data contains extra spaces or unusual characters, clean the data and calculate again.
Why does the SUBTOTAL result not match what I expect?
- Check whether the reference range is correct and confirm that the intended data area is selected.
- Check whether the function_num value matches your goal, such as sum, average, or count.
- Check whether hidden rows, filtered results, or nested SUBTOTAL formulas are affecting the result.
How do I use the SUBTOTAL function in multiple cells?
- Enter and confirm the SUBTOTAL formula in the first target cell.
- Select that cell, then drag the fill handle across the target range, or copy and paste the formula.
- After filling, check whether relative references changed and adjust the reference style if needed.
Glossary
| Term | Definition |
|---|---|
| SUBTOTAL | A spreadsheet function in WPS that performs subtotal calculations such as sum, average, and count for selected ranges. |
| function_num | The function code parameter in SUBTOTAL that determines which type of calculation is performed. |
| ref | A reference argument in SUBTOTAL that points to the cell or range used in the calculation. |