Document Editing Problems

Fix Duplicate Table Totals and Missing Bookmarks in Microsoft Word

Huma Ashraf ChHuma Ashraf Ch Nov 22, 2026 868 views

Question details

The user needs Word table formulas to calculate totals and averages correctly and recognize bookmarked values.

Fix Duplicate Table Totals and Missing Bookmarks in Microsoft Word
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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the calculation cells

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.

2
Insert an average formula

Click the average cell and choose Insert > Quick Parts > Field > Formula. Enter =AVERAGE(ABOVE) to average the applicable numeric cells above it.

3
Insert the total formula

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.

4
Update the results

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.

Replace Unnecessary Form Fields with Word Formula Fields
Creating field braces manually: To create a field code directly, press Ctrl+F9 on Windows or Cmd+F9 on Mac, then type the formula inside the inserted braces. Do not type or paste the braces as ordinary characters.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word DOCX and DOC filesWork with document tables in a familiar editing interfaceUse a free, lightweight office suite for everyday document editingMove existing Word files into WPS without starting documents from scratch
microsoft office alternative - wps office

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.