When using WPS Calculation Options on iOS, the most common questions involve calculation results, supported data types, and display status; this FAQ covers 3 common questions.
FAQ
Why are some cells not included in Sum or Average?
- Check whether the cell content is a valid number.
- Make sure there are no extra spaces or symbols in the cell.
- Select the range again and review the statistics bar one more time.
Why can’t I see the statistics bar at the top of the screen?
- Confirm that at least one cell or range is selected.
- Tap Tools and open the View tab.
- Check whether Show Sum/Count is turned on.
Can I copy a calculation result directly?
- Turn on Show Sum/Count and select the target range.
- Find the statistic you need in the bar at the top of the screen.
- Tap that result to copy it to the clipboard, then paste it where needed.
Glossary
| Term | Definition |
|---|---|
| Sum | The total value produced by adding the selected numbers together. |
| Count Numbers | The number of cells in the selection that contain valid numeric values. |
| Floating statistics bar | The information bar that appears at the top of the screen after Show Sum/Count is turned on. |