Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
Hi,
Provided you created the field braces (ie '{ }') via Ctrl-F9, 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 field-based calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/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
|
|||
|
|||
![]()
Hi macropod,
Thanks for your continuing help and the links. It works now. "macropod" wrote: Hi, Provided you created the field braces (ie '{ }') via Ctrl-F9, 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 field-based calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
Bookmark, X-Ref???? | 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 |