How to Insert the Sum Formula in a Word Table

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Tables in Word 2013 look similar to cells in an Excel spreadsheet, but unlike Excel, you can't start a formula simply by typing an equals sign. Word's formulas can also use a different notation, referring to sets of numbers by their relative position. To add table cells using the SUM function, insert a formula from the Layout tab.

Advertisement

Sum Cells in a Table

Video of the Day

Step 1: Start a Formula

Image Credit: Image courtesy of Microsoft

Click the target cell in your table, open the Layout tab and click Formula in the Data section.

Advertisement

Video of the Day

Step 2: Sum an Entire Direction

Image Credit: Image courtesy of Microsoft

Write a formula using the function =SUM to add cells. When you first open the formula window, Word defaults to the formula =SUM(ABOVE). If you want to add all cells above the selected cell, you don't need to change anything. To add cells from a different direction, change the formula to =SUM(BELOW), =SUM(LEFT) or =SUM(RIGHT).

Advertisement

Step 3: Change the Number Format

Image Credit: Image courtesy of Microsoft

Choose a number format, if needed. Without a number format selected, the formula's result appears without any formatting, akin to Excel's "General" formatting. Most of the time, you don't need to use a format. Word also lets you write your own format using the same system as in Excel. Click OK to finish the formula.

Advertisement

Advertisement

Step 4: Sum Specific Cells

Image Credit: Image courtesy of Microsoft

Refer to cell locations in a SUM function to add specific cells rather than an entire direction. Even though Word doesn't display row and column headings like Excel, it uses the same terminology: rows use numbers and columns use letters. For example, to add the cell three to the right, three down, and the cell below it, use the formula =SUM(C3:C4).

Advertisement

Insert an Excel Spreadsheet

Image Credit: Image courtesy of Microsoft

Another way to add cells in a Word document is to insert an Excel spreadsheet. Click Table on the Insert tab, as if inserting a table, but instead of choosing a table size, click Excel Spreadsheet. Inserted spreadsheets work exactly like spreadsheets in Excel, allowing you to simply type the function =SUM in the desired cell.

Advertisement

Advertisement

references

Report an Issue

screenshot of the current page

Screenshot loading...