calculating the difference from 2 different tables using the bookmark

Question

Hello!

I need to calculate the difference between 2 cells from different tables(B2 cell in each table) in the cell B2 of a third table and I tried to do it with bookmarks but it didn't work. I put a bookmark in the B2 cells of the first two tables and I named them m1 and m2. Then I went to cell b2 of the third table -> Formulas = m2-m1 and it says **!M2 Is Not In Table.**I really need to solve this problem. Please help me :)

Answer 1

Hi Daniel,

"m1" and "m2" can be cell locations as well as bookmark names.

Use bookmark names that cannot be the location of table cells or use Ref Fields to refer to the bookmarks rather than just the names. 

In the screenshot above you can see the bookmarks names in parentheses in the first two tables. a1 in Table 2 has two bookmarks assigned.

Table 3 has three formulae. The one you currently use does not work. Using bookmark names that cannot be the locations of table cells works. Using Ref fields (cross-reference to a bookmark) works.

This forum is a user-to-user support forum. I am a fellow user.

I hope this information helps.

Please let me know if you have any more questions or require further help.

Regards

Answer 2

Simply bookmark the source tables (technically the bookmarks needn't even span the whole table), then use a formula field like:

{=SUM(Tbl1 B2)-SUM(Tbl2 B2)}

where Tbl1 & Tbl2 are the bookmark names.

To see how to do a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:

http://www.msofficeforums.com/word/38720-microsoft-word-field-maths-tutorial.html

or:

http://www.gmayor.com/downloads.htm#Third_party

Answer 3

Not quite a genius, but you are welcome.

I've just been using Word for a loooong time and am familiar with some *(not all)*of its foibles.

Answer 4

You are a genius. Thank you very much!