Calculations in the table

Word 365 2016 2013 2010 2007
You can add, subtract, multiply, and divide numbers in Word table cells. Also you can calculate averages, percentages, and minimum as well as maximum values.

To add the formula to the Word table, do the following:

   1.   Click the table cell to which you want to insert a formula.

   2.   Select Table -> Formula.

  • If the cell that you have selected is at the bottom of a column of numbers, Microsoft Word will propose the formula = SUM(ABOVE):
    SUM formula in Word 2003
  • If the cell that you have selected is at the right end of a row of numbers, Word will propose the formula = SUM(LEFT).

   3.   In the Formula dialog box:

  • In the Paste function listbox, choose a function that you want to add.
  • To reference the contents of a table cell, type the cell references in the formula.
    The first column in a table is column A, the second column is column B, and so on. The first row is row 1, the second row is row 2, and so on. Thus, the cell in the second column and third row is cell B3.
    For example, to add the numbers in cells B1 and C3, the formula would read = SUM(b1,c3).
  • In the Number format listbox, choose a format for the numbers.

   4.   Click OK.

See also Price, sum, amount and other numbers in words.

Note: Word inserts the result of the calculation as a field in the cell that you have selected. If you change the values of the referenced cells, you can update the calculation by selecting the field and then pressing F9:

Field formula in Word 2003

If you need complex calculations in a table, you can create the table in Excel and then link or embed the table in your Word document so that you can update it using Excel.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more