WPS Calculation Options on iOS FAQ

Common questions about Calculation Options usually focus on where to find the feature, which results are shown, and how to reuse them; this FAQ covers 3 common questions and practical steps.

FAQ

Why did I select cells but still not see any summary results?

1. Make sure you opened a spreadsheet file instead of another document type.
2. Check whether you already turned on the summary panel from View with Turn on persistent sum and count or from the floating edit bar with Show sum.
3. Select a range that contains content again, then check whether the summary panel appears at the top of the screen.

What results can I review in the summary panel?

1. Select the cells or range that you want to summarize.
2. Open the summary panel.
3. Review the available results, including sum, average, maximum, minimum, count, and numerical count.

How can I quickly use a summary result somewhere else?

1. Display the summary panel first.
2. Tap the summary item that you want to reuse to copy it to the clipboard.
3. Open the target location and paste the copied value.

Glossary