Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.word.tables




Formula and Bookmark
Hello all,
I have 3 tables in my Word file. In Table 3, there is only one row with one cell, and in that cell, I want to have a formula to add the numbers from C5 and C7 in Table 1 and Table 2, respectively. I tried the formula {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3. Prior to inserting that formula, I created the bookmarks "Table1" and "Table2" by highlighting respective table and go to InsertBookmark. I am completely new to the writing a formula in Word and creating a bookmark. Please help with detail steps. Thanks. 
#2
Posted to microsoft.public.word.tables




Formula and Bookmark
Hi,
Try coding the field as: {=SUM(Table1 C5)+ SUM(Table2 C7)}  Cheers macropod [MVP  Microsoft Word] "Please Help" wrote in message ... Hello all, I have 3 tables in my Word file. In Table 3, there is only one row with one cell, and in that cell, I want to have a formula to add the numbers from C5 and C7 in Table 1 and Table 2, respectively. I tried the formula {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3. Prior to inserting that formula, I created the bookmarks "Table1" and "Table2" by highlighting respective table and go to InsertBookmark. I am completely new to the writing a formula in Word and creating a bookmark. Please help with detail steps. Thanks. 
#3
Posted to microsoft.public.word.tables




Formula and Bookmark
Hi macropod,
Thanks for the formula. I just tried that formula, and it did nothing. The cell stays blank. I wonder whether I bookmarked correctly. Basically, I highlighted Table 1. Then I went to InsertBookmark, and I typed in a name Table1 and clicked Add. I did the same for Table 2. Then I see brackets ([ ]) at the beginning and ending at each table. Did I do the bookmarks correctly? Thanks. "macropod" wrote: Hi, Try coding the field as: {=SUM(Table1 C5)+ SUM(Table2 C7)}  Cheers macropod [MVP  Microsoft Word] "Please Help" wrote in message ... Hello all, I have 3 tables in my Word file. In Table 3, there is only one row with one cell, and in that cell, I want to have a formula to add the numbers from C5 and C7 in Table 1 and Table 2, respectively. I tried the formula {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3. Prior to inserting that formula, I created the bookmarks "Table1" and "Table2" by highlighting respective table and go to InsertBookmark. I am completely new to the writing a formula in Word and creating a bookmark. Please help with detail steps. Thanks. 
#4
Posted to microsoft.public.word.tables




Formula and Bookmark
Hi,
Provided you created the field braces (ie '{ }') via CtrlF9, and the table bookmarks & cell references are correct, everything should work fine. Do note, though, that changing the source cell values does not of itself cause the formula to recalculate  you'll need to update the field by selecting it and pressing F9, doing a print preview or printing the document. For more information on fieldbased calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgibin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party  Cheers macropod [MVP  Microsoft Word] "Please Help" wrote in message ... Hi macropod, Thanks for the formula. I just tried that formula, and it did nothing. The cell stays blank. I wonder whether I bookmarked correctly. Basically, I highlighted Table 1. Then I went to InsertBookmark, and I typed in a name Table1 and clicked Add. I did the same for Table 2. Then I see brackets ([ ]) at the beginning and ending at each table. Did I do the bookmarks correctly? Thanks. "macropod" wrote: Hi, Try coding the field as: {=SUM(Table1 C5)+ SUM(Table2 C7)}  Cheers macropod [MVP  Microsoft Word] "Please Help" wrote in message ... Hello all, I have 3 tables in my Word file. In Table 3, there is only one row with one cell, and in that cell, I want to have a formula to add the numbers from C5 and C7 in Table 1 and Table 2, respectively. I tried the formula {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3. Prior to inserting that formula, I created the bookmarks "Table1" and "Table2" by highlighting respective table and go to InsertBookmark. I am completely new to the writing a formula in Word and creating a bookmark. Please help with detail steps. Thanks. 
#5
Posted to microsoft.public.word.tables




Formula and Bookmark
Hi macropod,
Thanks for your continuing help and the links. It works now. "macropod" wrote: Hi, Provided you created the field braces (ie '{ }') via CtrlF9, and the table bookmarks & cell references are correct, everything should work fine. Do note, though, that changing the source cell values does not of itself cause the formula to recalculate  you'll need to update the field by selecting it and pressing F9, doing a print preview or printing the document. For more information on fieldbased calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgibin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party  Cheers macropod [MVP  Microsoft Word] "Please Help" wrote in message ... Hi macropod, Thanks for the formula. I just tried that formula, and it did nothing. The cell stays blank. I wonder whether I bookmarked correctly. Basically, I highlighted Table 1. Then I went to InsertBookmark, and I typed in a name Table1 and clicked Add. I did the same for Table 2. Then I see brackets ([ ]) at the beginning and ending at each table. Did I do the bookmarks correctly? Thanks. "macropod" wrote: Hi, Try coding the field as: {=SUM(Table1 C5)+ SUM(Table2 C7)}  Cheers macropod [MVP  Microsoft Word] "Please Help" wrote in message ... Hello all, I have 3 tables in my Word file. In Table 3, there is only one row with one cell, and in that cell, I want to have a formula to add the numbers from C5 and C7 in Table 1 and Table 2, respectively. I tried the formula {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3. Prior to inserting that formula, I created the bookmarks "Table1" and "Table2" by highlighting respective table and go to InsertBookmark. I am completely new to the writing a formula in Word and creating a bookmark. Please help with detail steps. Thanks. 
#6
Posted to microsoft.public.word.tables




Formula and Bookmark
Hi,
You can create formulas using Word but there are alot of limitations. You might want to try "Formula Builder for MS Word." It has a free demo version at most major software download sites. "Please Help" wrote: Hello all, I have 3 tables in my Word file. In Table 3, there is only one row with one cell, and in that cell, I want to have a formula to add the numbers from C5 and C7 in Table 1 and Table 2, respectively. I tried the formula {=sum(Table1 C5 + Table 2 C7)} in the cell in Table 3. Prior to inserting that formula, I created the bookmarks "Table1" and "Table2" by highlighting respective table and go to InsertBookmark. I am completely new to the writing a formula in Word and creating a bookmark. Please help with detail steps. Thanks. 
Reply 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Forum  
Bookmark, XRef????  Microsoft Word Help  
Bookmark  New Users  
My noteref to valid bookmark says "Error! Bookmark not defined."?  Microsoft Word Help  
The Insert Bookmark box shouldnt vanish after adding a bookmark.  Microsoft Word Help  
how to align caption of formula right whereas formula itself left  Microsoft Word Help 