Document Editing Problems

How to Fix the Word Table Error 'B12 Is Not in Table'

John Wilson Oct 10, 2026 870 views

Question details

The user needs to resolve an error that prevents the =SUM(ABOVE) formula from calculating correctly in a document table.

How to Fix the Word Table Error 'B12 Is Not in Table'

Product: Word
Device & OS: not provided
Scenario: Attempting to calculate the total of numerical values in a document table using the =SUM(ABOVE) function.
Observed behavior: Instead of returning the calculated sum, the formula field displays an error reading 'B12 is not in Table'.

Before you start

Verify that your text cursor is placed actively inside a table cell before inserting the formula, and ensure that the cells directly above the target cell contain valid numerical data rather than text or blank spaces.

Solution 1Recommended

Verify Formula Placement and Syntax

Ensure the formula is inserted correctly inside the table using the dedicated Table Layout tools.

The most common reason for this error is that the formula is either placed outside the table boundaries or was manually typed as regular text. You must use the built-in formula dialog to generate the field correctly.

Select the target cell

Click inside the empty cell at the bottom of the column where you want the total sum to appear.

Open the Formula dialog

Navigate to the 'Table Layout' tab on the top ribbon and click on 'Formula' in the Data group.

Insert the SUM formula

In the Formula box, ensure the text reads exactly =SUM(ABOVE). Click OK to apply the calculation.

Solution 2

Repair a Damaged Table Structure

Convert the corrupted table to plain text and back into a table to reset its internal properties.

Solution 3

Manually Recreate the Field Code

Use keyboard shortcuts to manually force a fresh field code generation, bypassing menu glitches.

Calculate Table Data Seamlessly in WPS Writer

WPS Writer offers an intuitive Table Tools layout, making it incredibly easy to insert formulas like =SUM(ABOVE) without encountering field code errors. It provides smooth calculation features fully compatible with Microsoft Word documents.

1. Open your document: Launch WPS Writer and open the document containing your data table.
2. Select the cell: Click inside the empty table cell where you want to calculate the total sum.
3. Insert the formula: Navigate to the 'Table Tools' tab, click on 'Formula', ensure it says =SUM(ABOVE), and click OK.

Intuitive and user-friendly Table Formula insertion toolSeamless format compatibility with Microsoft Word (.docx)Free and lightweight alternative for daily document editingAutomatic and accurate field updates for all table calculations

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word think my formula is outside the table?

This happens if the text cursor was accidentally placed just outside the table borders before inserting the formula, or if the table structure has become split or corrupted during editing.

Can I use standard Excel formulas in a Word table?

Word tables support basic calculation formulas like =SUM(ABOVE) or specific cell references (like A1, B2), but they do not support the advanced functions and complex array formulas found in Excel.

How do I update a formula in a table after changing the numbers?

Word and Writer table formulas do not always update automatically in real time. To update the calculation, select the formula result in the cell and press F9, or right-click it and choose 'Update Field'.

Document & File Issues