# 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.

See also this tip in French: Calculs dans le tableau.