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.

Windows • MacOS • Linux • iOS • Android

# How to use the formula function of table in WPS Writer

Uploaded time: February 25, 2022 Difficulty Beginner

# How to use the formula function of table in WPS Writer

How to use the formula function of table in WPS Writer

You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore.

Take this table as an example.

Assume that we want to count how many **Expense** there are in the whole table. We can use the **COUNT** function to count the number of data in the table.

Tips: The **COUNT **function in WPS can only be applied in counting number data, while the empty cells, logical values, or text data will be omitted.

Place the cursor in the empty cell at the bottom of the **Account number** column. In the **Table Tools** tab, click the **Formula** data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/68116c406ef7c420a525dd9f7c21fd61_0.46_1699.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720));
text-align:center;" >

In the **Paste function** area, select the **COUNT **function. In **Table area**, select **Above** data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/fae487e2ba2b774ededcb978c3a4d9c9_0.46_6563.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720));
text-align:center;" >

Now, suppose that we want to calculate the average of **Expense details**.

Likewise, click the **Formula** button under the **Table Tools** data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/8229b9a61b793e6fdad58e68a6119048_0.46_6455.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720));
text-align:center;" >

In **Paste function**, choose the **AVERAGE **function, and set **Table area** as **Above**. In the **Number format** area, we can choose from different formats as needed, such as the thousands separator **#,##0**.

Click OK to return the calculation result in the empty cell at the bottom of the **Expense details** data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/a4029f967448ec95ab14ef19996cabb8_0.46_7276.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720));
text-align:center;" >

Additionally, assume that we want to calculate the average of air-delivery fee, we can select the result we've got before and right-click to choose **Edit Field**. In the dialog, we can reset the range of values to calculate the average, that is, change **Above** to **D15:D19**.

Click OK to return the calculation result in the empty cell at the bottom of the **Expense details** data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/6f273d3805d538a6740985ff0105ffe7_0.46_7905.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720));
text-align:center;" >

Alternatively, we can press the shortcut key **Shift+F9** to activate the **Toggle Field Codes** function. Thus, the calculation result is changed to **Field Codes**, and the formula can be set directly.

For instance, we can change the calculated range of values back to **Above** and press **Shift+F9** to exit the edit interface. Finally, press **F9** data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/f5811034d9215634dda763991fdbb526_0.46_2593.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720));
text-align:center;" >

In addition to the ones mentioned above, WPS Writer provides plenty of functions for users to apply in the table. Have a try now!

Also Read:

- 1. How to adjust the overall width and font position of the table in WPS Writer
- 2. Insert a table into the text & convert between text and table
- 3. How to use the fast calculation function of table in WPS Writer
- 4. How to set the table properties in WPS Writer
- 5. How to display the obscured table text in WPS Writer
- 6. Merge and split table cells in WPS Writer

Does this video help you?