Formula and Bookmark

[Please Help]

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 Insert>Bookmark.

I am completely new to the writing a formula in Word and creating a
bookmark. Please help with detail steps.

Thanks.

 

[macropod]

Hi,

Try coding the field as:
{=SUM(Table1 C5)+ SUM(Table2 C7)}

 

[Please Help]

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 Insert>Bookmark, 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.

Hi,

Try coding the field as:
{=SUM(Table1 C5)+ SUM(Table2 C7)}

--
Cheers
macropod
[MVP - Microsoft Word]

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 Insert>Bookmark.

I am completely new to the writing a formula in Word and creating a
bookmark. Please help with detail steps.

Thanks.

 

[macropod]

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/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

--
Cheers
macropod
[MVP - Microsoft Word]

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 Insert>Bookmark, 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.

Hi,

Try coding the field as:
{=SUM(Table1 C5)+ SUM(Table2 C7)}

--
Cheers
macropod
[MVP - Microsoft Word]

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 Insert>Bookmark.

I am completely new to the writing a formula in Word and creating a
bookmark. Please help with detail steps.

Thanks.

 

[Please Help]

Hi macropod,

Thanks for your continuing help and the links. It works now.

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/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

--
Cheers
macropod
[MVP - Microsoft Word]

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 Insert>Bookmark, 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.

Hi,

Try coding the field as:
{=SUM(Table1 C5)+ SUM(Table2 C7)}

--
Cheers
macropod
[MVP - Microsoft Word]


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 Insert>Bookmark.

I am completely new to the writing a formula in Word and creating a
bookmark. Please help with detail steps.

Thanks.