Adding up cell values in a table in Microsoft Word 2019

Although Excel would be the go-to application forcalculating data, calculations can be performed within Word tables. Wecould create a formula to add sales values, work out percentagecommission, or multiply values:

  1. Click where you would like your answer to be (that is, place yourcursor in the total cell).
  2. On the Layout tabunder Table Tools, choosethe Formula icon, asillustrated in the following screenshot:

ms office 110

  1. The Formula dialog box will openand will automatically enter a formula to add values in a table cell,as illustrated in the following screenshot:

ms office 684

  1. Check that the formula is correct. (Word automatically assumes thatwe are adding all the values above, which is correct in this example.Always double-check after the calculation is assumed by Word, as you maywish to alter the formula to =sum[LEFT] if you are to add allthe values to the left, or =sum[RIGHT] to add all the valuesto the right of the formula cell.)
  2. Click on OK.

To update a formula, press F9 on your keyboard. If youchange any of the table values, which will have an impact on any formulain the table, select the table and press F9 on your keyboard toupdate the formula. Alternatively, right-click on the answer, and selectUpdate Fieldas illustrated inthe following screenshot:

ms office 380

To multiply, subtract, or divide in a Word table, simply use the rowsand column cell references in the formula. For example, to sum up thevalues 9000 + 4567 to reach a total, you would need to usecolumn B and row 2 and column B and row3 to identify the cell references for the cells to use in theformula to obtain the total in column C, row 6.

This feature can be used for quotations, invoicing, and so on.

Leave a Comment