Reply
 
Thread Tools Display Modes
  #1   Report Post  
Eric
 
Posts: n/a
Default calculation with two tables

Hi!
There are two separate tables on my document and there is a total field
(=sum(above)) at the last row of the first table. I want to also show that
total value of the first table at the first row of the second table. Because
there is another calculation on the second table.
Can I add a field at the first row of the second table to refresh the value
from the first table? How?
Thank you very much!
  #2   Report Post  
Luc
 
Posts: n/a
Default

Eric,
Select your total in the first table. Bookmark it, Insert - bookmark - type
a name like firsttotal - OK
In the first row of your second table use a ref field, Insert - Field -
Ref - select your bookmark - OK.
You will have to recalculate using Ctrl+a - F9 to update after changes made
to the numbers in your table.
Luc
"Eric" schreef in bericht
...
Hi!
There are two separate tables on my document and there is a total field
(=sum(above)) at the last row of the first table. I want to also show that
total value of the first table at the first row of the second table.
Because
there is another calculation on the second table.
Can I add a field at the first row of the second table to refresh the
value
from the first table? How?
Thank you very much!



  #3   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?RXJpYw==?=,

There are two separate tables on my document and there is a total field
(=sum(above)) at the last row of the first table. I want to also show that
total value of the first table at the first row of the second table. Because
there is another calculation on the second table.
Can I add a field at the first row of the second table to refresh the value
from the first table? How?

Yes. It's described in the Help files...

"To reference cells in another table, or to reference a cell from outside a
table, identify the table with a bookmark. For example, the field {
=average(Table2 b:b) } averages column B in the table marked by the bookmark
Table2."

What this doesn't tell you is:
- You need to select the entire table, then Insert/Bookmark and type in the
bookmark name (Table2, for example)
- This only works when you use the bookmark in a FUNCTION. If you only want
to show the result of a single cell, you still need to do something like
{ = SUM(Table1 A1:A1) }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

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
When joining tables, table sections shift left or right. JEB01 Tables 1 January 17th 05 07:57 PM
Merging tables in Word 2003 JoanN Microsoft Word Help 3 December 21st 04 06:35 PM
insert a table bwtween a series of tables Series of tables Tables 2 November 9th 04 10:19 PM
Is there a way to "join" tables in Word 2003? Julian Turner Tables 3 October 28th 04 06:51 PM


All times are GMT +1. The time now is 11:41 AM.

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

About Us

"It's about Microsoft Word"