WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


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


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to use the fast calculation function of table in WPS Writer

Uploaded time: February 28, 2022 Difficulty Beginner

How to use the fast calculation function of table in WPS Writer

How to use the fast calculation function of table in WPS Writer

Do you know how to perform statistical operations on tabular data inserted in a document? It teaches you to perform quick calculations in a document in one minute.

For example, let's say we want to figure out the total sales of small businesses in Q1 for all regions.

First of all, insert a total column on the right of the table,

select the data cell of row Q1, click the Table Tools tab, click the Fast Calculation drop-down button, and select Sum to calculate the Sum of the data in this row.

Select the data cells in the remaining rows to quickly figure out the total sales for each quarter for all regions to the left.

For example, find the total sales of small businesses in Asia. Using the same op data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/90561ba75c02b12f1f5b790163424a32_0.46_1872.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720)); text-align:center;" >

In addition, we can also use the Fast Calculation function to find the Average value of the table data, Max value,and Min value.How_to_use_the_fast_calculation_function_of_table_in_WPS_Writer_4.gif

Have you learned this simple and practical function?

WPS Office Spreadsheet is helpful for various fields of studies: mathematics, statistics, data science, engineering, finance, and such. Rich in functions paired with teaching procedures, WPS Office Spreadsheet definitely is a professional and reliable toolkit.

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