How to Insert the Sum Formula in a Word Table

Techwalla may earn compensation through affiliate links in this story.

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

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

Report an Issue

screenshot of the current page

Screenshot loading...