How to Use SUM and Formulas in a Microsoft Word Document
Question details
The user needs to perform mathematical calculations like SUM within a Word document table without relying on an external spreadsheet application.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Calculating totals such as sums, taxes, or other values within a document table imported from an external source that does not support Excel.
- Observed behavior
- Word tables support formulas like =SUM(ABOVE) or =SUM(LEFT), but unlike Excel, these formulas do not update automatically when cell values change and require manual refreshing.
Ensure your numerical data is organized within a document table, as Word formulas require a table structure to reference specific cells or directional values.
Use the Formula Command in Table Layout
Insert a mathematical formula directly into a table cell to calculate directional values like columns or rows.
Click inside the empty cell where you want the calculation result to appear.
Go to the 'Layout' tab (under Table Tools) on the ribbon and click on 'Formula' in the Data group.
In the Formula dialog box, Word may automatically suggest a formula like =SUM(ABOVE). You can keep it or modify it to =SUM(LEFT), then click OK.

Calculate Using Specific Cell References
Use standard column and row referencing (e.g., A1, B2) for more complex calculations across a Word table.
Calculate Table Data Easily in WPS Writer
WPS Writer fully supports formula calculations within document tables, allowing you to easily sum rows or columns without switching to a spreadsheet program.
- 1. Insert your table: Create a table in WPS Writer and populate it with your numeric data.
- 2. Select the result cell: Click on the empty table cell where you want the final calculation to be displayed.
- 3. Access Table Tools: Navigate to the 'Table Tools' tab on the top ribbon and select 'Formula'.
- 4. Apply the formula: Choose or type your desired formula, such as =SUM(ABOVE), and click OK to instantly generate the result.

Frequently Asked Questions
Why isn't my Word formula updating when I change the numbers?
Unlike Excel, formulas in Word do not recalculate automatically when you modify table data. You must manually update the field by selecting the formula cell and pressing the F9 key on your keyboard.
Can I use functions other than SUM in a Word table?
Yes, Word supports several basic functions including AVERAGE, MIN, MAX, COUNT, and PRODUCT. You can select these from the 'Paste function' drop-down list inside the Formula dialog box.
How do I calculate percentages or taxes in a Word document?
You can use standard arithmetic operators (+, -, *, /) along with cell references in the Formula dialog. For example, to calculate a 5% tax on cell A2, you would enter =A2*0.05.
What happens if I have blank cells in the column I am summing?
If you use =SUM(ABOVE) and there is a blank cell in the column, Word will only sum the values directly below the blank cell. To avoid an incomplete calculation, enter a zero (0) in any empty cells within that column.




