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

"macropod" wrote:

> Hi,
>
> Try coding the field as:
> {=SUM(Table1 C5)+ SUM(Table2 C7)}
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "Please Help" <PleaseHelp DeleteThis @discussions.microsoft.com> wrote in message news:8C80B55C-4FA4-4050-B53F-53DF7B4DF51A@microsoft.com...
> > 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.
>

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]


"Please Help" <PleaseHelp RemoveThis @discussions.microsoft.com> wrote in message news:A129B2B8-AFA7-440E-B4F6-8CF5FD783DB2@microsoft.com...
> 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.
>
> "macropod" wrote:
>
>> Hi,
>>
>> Try coding the field as:
>> {=SUM(Table1 C5)+ SUM(Table2 C7)}
>>
>> --
>> Cheers
>> macropod
>> [MVP - Microsoft Word]
>>
>>
>> "Please Help" <PleaseHelp RemoveThis @discussions.microsoft.com> wrote in message news:8C80B55C-4FA4-4050-B53F-53DF7B4DF51A@microsoft.com...
>> > 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.
>>

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/showthreaded.pl?Number=365442
> or
> http://www.gmayor.com/downloads.htm#Third_party
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "Please Help" <PleaseHelp.RemoveThis@discussions.microsoft.com> wrote in message news:A129B2B8-AFA7-440E-B4F6-8CF5FD783DB2@microsoft.com...
> > 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.
> >
> > "macropod" wrote:
> >
> >> Hi,
> >>
> >> Try coding the field as:
> >> {=SUM(Table1 C5)+ SUM(Table2 C7)}
> >>
> >> --
> >> Cheers
> >> macropod
> >> [MVP - Microsoft Word]
> >>
> >>
> >> "Please Help" <PleaseHelp.RemoveThis@discussions.microsoft.com> wrote in message news:8C80B55C-4FA4-4050-B53F-53DF7B4DF51A@microsoft.com...
> >> > 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.
> >>
>
>

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 Insert>Bookmark.
>
> I am completely new to the writing a formula in Word and creating a
> bookmark. Please help with detail steps.
>
> Thanks.