Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When joining tables, table sections shift left or right. | Tables | |||
Merging tables in Word 2003 | Microsoft Word Help | |||
insert a table bwtween a series of tables | Tables | |||
Is there a way to "join" tables in Word 2003? | Tables |