# Calculations in the table

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

** 1. ** Click the table cell in which you want to insert a formula. Word adds **Table Tools** ribbons: **Design** and **Layout**:

** 2. ** On the **Layout** tab, in the **Data** group, click the **Formula** button:

- If the cell you selected is at the bottom of a column of numbers, Microsoft Word proposes the formula
:**= SUM(ABOVE)** - If the cell you selected is at the right end of a row of numbers, Word proposes 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, the second column is column**A**, and so on. The first row is row**B**, the second row is row**1**, and so on. Thus, the cell in the second column and third row is cell**2**.**B3**

For example, to add the numbers in cellsand**B1**, the formula would read**C3**.**= 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 you selected. If you change the values in the referenced cells, you can update the calculation by selecting the field and then pressing

**F9**:

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