How to Sum a Table Column in Microsoft Word (2026)

Word’s built-in Formula feature lets you sum a table column without leaving your document, but it works very differently from Excel, and a few quirks can trip you up. These steps apply to Word for Microsoft 365, Word 2021, 2019, and 2016 on Windows and Mac. Word for the web and mobile apps don’t support this feature, so you’ll need the desktop app.

Sum a Table Column on Windows (Word for Microsoft 365, 2021, 2019, 2016)

Step 1: Click the empty cell where you want the total

Click inside the blank cell at the bottom of the column you want to sum. Your cursor must be inside the table for the next step to work.

Step 2: Open the Formula dialog

1. With your cursor in the table, the Table Design and Layout tabs appear in the ribbon.
2. Click the Layout tab.

3. In the Data group on the far right of the ribbon, click Formula.

Step 3: Confirm the formula and choose a number format

The Formula dialog opens. Word usually pre-fills the formula box with =SUM(ABOVE) when your cursor is at the bottom of a column. Leave it as-is if that’s what you want.

1. Check the Formula box. It should read =SUM(ABOVE). If it doesn’t, type it in manually.
2. (Optional) Click the Number format drop-down and pick a format. For plain decimals, choose 0.00. For currency, choose $#,##0.00.
3. Click OK.

Word inserts a field that displays the calculated total in the cell.

Step 4: Update the total after changing numbers

Word does not recalculate automatically when you edit the table. After changing any values, do one of the following:

• Right-click the total cell and select Update Field.
• Click the total cell and press F9.
• Press Ctrl+A to select everything, then press F9 to update all fields in the document at once.

Sum a Table Column on Mac (Word for Microsoft 365, 2021, 2019, 2016)

The steps are nearly identical on Mac, with one naming difference: the contextual tab is called Table Layout instead of Layout.

1. Click the empty cell at the bottom of the column.
2. Click the Table Layout tab in the ribbon.
3. Click Formula on the right side of the tab.
4. Confirm the formula reads =SUM(ABOVE), choose a number format if needed, and click OK.
5. To update after changes: right-click the total and select Update Field, or press F9.

Other SUM directions

=SUM(ABOVE) isn’t the only option. You can change the direction depending on where your data is:

Formula	Sums
=SUM(ABOVE)	All numbers in the column above the formula cell
=SUM(BELOW)	All numbers in the column below the formula cell
=SUM(LEFT)	All numbers in the row to the left
=SUM(RIGHT)	All numbers in the row to the right
=SUM(D2:D6)	Specific cells by column/row reference

Add the Sum button to the Quick Access Toolbar

If you sum table columns frequently, you can add a Sum button to the Quick Access Toolbar so it’s always one click away, with no need to navigate to the Layout tab each time.

1. Click File > Options.
2. Select Quick Access Toolbar from the left panel.
3. In the Choose commands from drop-down, select Commands Not in the Ribbon.

4. Scroll down and select Sum.
5. Click Add, then click OK.

The Sum button now appears in your Quick Access Toolbar. Click it while your cursor is in the bottom cell of a column to insert =SUM(ABOVE) instantly.

Common problems and fixes

Fix #1: The cell shows { =SUM(ABOVE) } instead of a number

You’re seeing the field code instead of the result. Word is toggling between displaying the formula and displaying the output.

1. Press Alt+F9 to toggle back to results view.
2. If the cell still shows the code, click it and press F9 to force an update.

Fix #2: The total is wrong, it’s only summing part of the column

=SUM(ABOVE) stops counting when it hits a blank cell or a cell containing text. If your column has any empty rows, the formula only picks up the numbers directly above it until it hits the gap.

The most reliable fix is to use an explicit cell range instead of ABOVE:

1. Double-click the total cell to select the field.
2. Open the Formula dialog again (Layout > Formula).
3. Replace =SUM(ABOVE) with an explicit range like =SUM(D2:D6), where D is the column letter and the numbers match your data rows.
4. Click OK, then press F9 to update.

Alternatively, put a 0 in any blank cells in the column so =SUM(ABOVE) has no gaps to stop at.

Fix #3: The total keeps getting larger every time I update it

This happens when a column contains more than one formula cell and =SUM(ABOVE) is picking up another total as part of its range, creating a circular-style inflation each time you update.

1. Replace =SUM(ABOVE) with explicit row references to include only the data cells, for example: =SUM(D2:D5) (excluding the subtotal row).
2. Press F9 to recalculate.

Fix #4: The Formula button is grayed out

The Formula button only activates when your cursor is inside a table. If the button is grayed out:

1. Click inside any cell in your table.
2. Confirm that the Table Design and Layout tabs appear in the ribbon.
3. If you’re using Word for the web or the Word mobile app, the Formula button isn’t available. Open the document in the desktop app instead.

When to use Excel instead

Word’s table formulas don’t auto-recalculate, don’t support drag-fill, and can behave unpredictably with blank cells or mixed content. For anything beyond a simple one-column total, such as invoices, budgets, or comparison tables, embedding an Excel spreadsheet directly in Word is more reliable.

1. In Word, go to Insert > Table > Excel Spreadsheet.
2. Enter your data and use standard Excel formulas like =SUM(D2:D6).
3. Click outside the spreadsheet to return to Word. The table displays inline in your document and recalculates automatically when you double-click to edit it.

Conclusion

For a quick column total, the Layout > Formula method works well. Fix #2 (switching from =SUM(ABOVE) to an explicit range like =SUM(D2:D6)) is worth doing by default if your table has any blank rows or multiple totals. If you find yourself updating fields manually every time the numbers change, the embedded Excel spreadsheet approach will save you a lot of frustration in the long run.