How to Use WPS Calculation Options on Android

Use Calculation Options with 2 how-to topics, both available without membership; you can view summary results from View or from the floating edit bar.

How-to Index

How-to Guide

1. Turn on the persistent sum and count display

Entry: View → Turn on persistent sum and count display

1. Select the cells or range that you want to calculate and count.
2. Tap the View tab at the bottom of the screen.
3. Turn on Turn on persistent sum and count display.
4. Check the top of the screen for sum, average, maximum, minimum, count, and numerical count.
5. To reuse a result, tap any summary value to copy it to the clipboard.
6. When you are done, tap the X on the left side of the summary panel to close the persistent display.

Success Criteria

• Interface result: A summary panel appears at the top of the screen and shows multiple calculation results for the current selection.
• What you can do next: You can switch to another selection or tap a summary value to copy it.

Tips While Using

• Common mistake: If no cells are selected first, the summary results may not appear as expected.
• Environment note: The panel only summarizes the currently selected data range.

2. Show sum from the floating edit bar

Entry: Floating edit bar → More actions → Show Sum

1. Tap to select the cells or range that you want to calculate and count so the floating edit bar appears.
2. In the floating edit bar, tap More actions.
3. Tap Show Sum.
4. Check the summary panel at the top of the screen.

Success Criteria

• Interface result: The sum and count panel appears at the top of the screen.
• What you can do next: You can continue reviewing the summary results or select another range to recalculate.

Tips While Using

• Common mistake: If the floating edit bar does not appear, tap the target cell or range again.
• Environment note: The summary results update when the current selection changes.