WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to quickly sum the table data in WPS Writer

February 13, 2023
9.7K Views

· Option 1

1. Open the file in WPS Writer.

2. Then click the table, now we will automatically jump to the Table Tools tab interface. If not, click the Table Tools tab to jump manually.

3. Select the data area we want to calculate.

4. Then click the Fast Calculation drop-down button.

5. We can select different calculation method in the drop-down menu. Here, we will choose Sum.

· Option 2

1. Click on the cell we want to enter the calculation result.

2. The click the Table Tools tab and then click the Formula button. Then a Formula dialog box will pop up.

3. We can enter the needed formula in the Formula input box. Here, WPS will automatically enter the sum formula for us.

4. Then click OK.

This skill could also be used in Microsoft Office Word and OpenOffice.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.