Fix Duplicate Table Totals and Missing Bookmarks in Microsoft Word
Question details
The user needs Word table formulas to calculate totals and averages correctly and recognize bookmarked values.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Calculating averages and totals in a Word table, including formulas that refer to bookmarked cells.
- Observed behavior
- Totals and averages appear duplicated, and formulas that reference bookmarks report that the bookmarks cannot be found.
Check the table layout and identify the cells that contain source values, averages, and totals. Note the bookmark names and whether the document uses form fields or is protected for form filling.
Replace Unnecessary Form Fields with Word Formula Fields
Use formula fields to calculate table values when the document does not need protected form filling.
Form fields are generally unnecessary for ordinary table calculations unless the document is protected for form filling. Confirm that each formula references the intended cells; the correct references depend on the table layout.
Click each average or total cell and check whether it contains a form field or a formula field. If the document does not need form filling, replace unnecessary form fields with formula fields.
Click the average cell and choose Insert > Quick Parts > Field > Formula. Enter =AVERAGE(ABOVE) to average the applicable numeric cells above it.
Click the total cell and insert a Formula field containing =B3+C3 if B3 and C3 are the cells to add. Adjust the references to match your table.
Select each average field and press F9 to update it, then select the total field and press F9. Check that the total adds the calculated values rather than displaying adjacent values as text.

Restore and Verify Bookmarks Used by Table Formulas
Use this method when a formula reports that a referenced bookmark cannot be found.
Edit Word Documents with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Word documents. Its format compatibility makes it easy to move existing files into WPS, although Word-specific field and bookmark behavior should be checked after migration.

Frequently Asked Questions
Why does my Word table total show 99 instead of 9?
The displayed values may be adjacent text or the calculation may use the wrong fields or references. Check the total cell and insert a Formula field such as =B3+C3, using the actual cells that contain the two values.
How do I update a table formula after changing a value?
Select the formula field and press F9. If a total depends on average fields, update the averages first and then update the total.
Why can't Word find a bookmark used in my formula?
The bookmark name may be misspelled, or the bookmark may have been removed when its content was edited. Open Insert > Bookmark to check the name and recreate it around the intended value if needed.
Can I type the braces around a Word field code?
No. Use Ctrl+F9 on Windows or Cmd+F9 on Mac to insert field braces, or choose Insert > Quick Parts > Field > Formula. Typed braces are ordinary text, not a field.




