How to Use WPS Calculation Options on Android

Use Calculation Options through 2 how-to topics, including turning Show Sum on and turning Show Sum off, then follow the entry path and steps below.

How-to Index

How-to Guide

1. Turn on Show Sum and Count

Feature entry: Tools → View → Show Sum

1. Select the cells or range that you want to review.
2. Tap Tools at the bottom of the screen.
3. Open the View tab.
4. Turn on Show Sum.
5. Review Sum, Average, Max, Min, Count, and Numerical Count in the floating summary bar at the top of the screen.
6. Tap any displayed result if you want to copy it to the clipboard.

Success Criteria

• Interface result: a floating summary bar appears at the top of the screen.
• What you can do next: review and copy summary values.

Tips While Using

• Common mistake: if no cells or range are selected first, the summary may not match what you expect.
• Environment note: only pure numeric content can participate in sum or average calculations; values with spaces or symbols may not be counted as numbers.

2. Turn off Show Sum and Count

Feature entry: Tools → View → Show Sum

1. Tap Tools at the bottom of the screen.
2. Open the View tab.
3. Turn off Show Sum.
4. Return to the worksheet and confirm that the floating summary bar is hidden.

Success Criteria

• Interface result: the floating summary bar no longer appears at the top of the screen.
• What you can do next: continue editing the spreadsheet normally.

Tips While Using

• Common mistake: if the summary bar is still visible, check whether the Show Sum switch is fully turned off.