Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Please Help Please Help is offline
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default 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   Report Post  
Posted to microsoft.public.word.tables
Please Help Please Help is offline
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Formula and Bookmark

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   Report Post  
Posted to microsoft.public.word.tables
Please Help Please Help is offline
external usenet poster
 
Posts: 3
Default 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 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   Report Post  
Posted to microsoft.public.word.tables
Microsmith Microsmith is offline
external usenet poster
 
Posts: 9
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bookmark, X-Ref???? Connie Martin Microsoft Word Help 4 December 19th 07 11:52 PM
Bookmark Alan T New Users 5 January 31st 07 10:09 AM
My noteref to valid bookmark says "Error! Bookmark not defined."? jchilders_98 Microsoft Word Help 3 October 5th 06 02:23 PM
The Insert Bookmark box shouldnt vanish after adding a bookmark. RogerKni Microsoft Word Help 4 September 26th 06 03:13 PM
how to align caption of formula right whereas formula itself left Martin van Leeuwen Microsoft Word Help 1 October 22nd 05 06:39 AM


All times are GMT +1. The time now is 11:59 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"