If you’re working in Word and you need to sum the values in a table, you can choose not to enter the data in Excel so you can copy and paste it into Word later. Word is capable of performing simple calculations such as addition, multiplication, or rounding.
Note: When you add new rows or columns with values to a Word table, the formulas won’t update automatically. To update a formula, right-click on it and select Update Field (Update field) from the drop down menu.
To enter a formula in a table cell, position the cursor in the cell and open the tab layout (Layout) in a tab group Table Tools (Working with tables).
On the Advanced tab layout (Layout) section Data (Data) click on Formula (Formula).
In our example, we will multiply Units (Number of units) per Unit cost (Unit cost), and then display the total in the column Total (Total). To multiply two numbers from the cells to the left of the current one, enter the following text in the input field Formula (Formula):
=PRODUCT(LEFT)
Select the desired option from the dropdown list Number format (Number Format) to specify the form of the result of the calculation.
Note: For more information on available formulas and how to use them, visit the Microsoft office website.
Press OKto confirm the settings and attach the formula to the cell.
From now on, the result of the calculation is displayed in the cell.
Note: If you right-click on the cell containing the formula and select from the drop-down menu Toggle Field Codes (Field codes / values), you will see the formula assigned to it, as shown in the first picture of this article. Right click and select again Toggle Field Codes (Field codes/values) to display the work again.
We did the same steps to multiply Units (Number of units) and Unit Cost (Unit cost) on each following line.
Now make sure that there is an extra line at the bottom of the plate in order to sum up all the prices. Place the cursor in an empty cell at the bottom of a column Total (Total). To display a dialog box Formula (Formula), click on Formula (Formula) section Data (Data) tab layout (Layout). Enter the following formula in the dialog box Formula (Formula). Most likely, the default formula will be “=SUM(ABOVE)«.
Select the appropriate number format and click OK.
Now this cell displays the total of the entire column Total (Summary).
