Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Suming or dividing elements from different tables
Hi,
I have two tables, table1 and table2. I want to write a formula to calculate the sum of element at cell a1 of table1 and the element at cell a1 of table2. So, 1.) What is the formula for doing this? 2.)What is the formula for just displaying the element at cell a1 of table1? 3.)What is the formula of dividing the element at cell a1 of table1 by the element at cell a1 of table2? Thank you |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Suming or dividing elements from different tables
Hi,
I have two tables, table1 and table2. *I want to write a formula to calculate the sum of element at cell a1 of table1 and the element at cell a1 of table2. *So, 1.) What is the formula for doing this? 2.)What is the formula for just displaying the element at cell a1 of table1? 3.)What is the formula of dividing the element at cell a1 of table1 by the element at cell a1 of table2? Sorry that I missed one thing. All the formulae above are to be embedded in a cell of table 3. Thank you. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Suming or dividing elements from different tables
Hi,
I have two tables, table1 and table2. *I want to write a formula to calculate the sum of element at cell a1 of table1 and the element at cell a1 of table2. *So, 1.) What is the formula for doing this? 2.)What is the formula for just displaying the element at cell a1 of table1? 3.)What is the formula of dividing the element at cell a1 of table1 by the element at cell a1 of table2? Sorry that I missed one thing. All the formulae above are to be embedded in a cell of table 3. Thank you. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Suming or dividing elements from different tables
You need to create a bookmark in each table that has elements you want
to use in your calculation. The bookmark can "cover" the table or just be somewhere inside the table. Let's say the bookmark for table1 is called "table1" and the bookmark for table2 is called "table2" Then for your (2) you can use { =SUM(table1 a1, table2 a1)} These table references only work within a few functions in the { = } field so you can't do things like { =table1 a1 } { =table1 a1 + table2 a1 } or { =table1 a1 * table2 a1 } so to do your (3) you have to use something like { =SUM(table1 a1}/SUM(table2 a1) } (The {} need to be the special field code braces that you can insert using ctrl-F9) Peter Jamieson http://tips.pjmsn.me.uk On 21/01/2010 12:24, cyberdude wrote: Hi, I have two tables, table1 and table2. I want to write a formula to calculate the sum of element at cell a1 of table1 and the element at cell a1 of table2. So, 1.) What is the formula for doing this? 2.)What is the formula for just displaying the element at cell a1 of table1? 3.)What is the formula of dividing the element at cell a1 of table1 by the element at cell a1 of table2? Thank you |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Suming or dividing elements from different tables
You need to create a bookmark in each table that has elements you want
to use in your calculation. The bookmark can "cover" the table or just be somewhere inside the table. Let's say the bookmark for table1 is called "table1" and the bookmark for table2 is called "table2" Then for your (2) you can use { =SUM(table1 a1, table2 a1)} These table references only work within a few functions in the { = } field so you can't do things like { =table1 a1 } { =table1 a1 + table2 a1 } or { =table1 a1 * table2 a1 } so to do your (3) you have to use something like { =SUM(table1 a1}/SUM(table2 a1) } (The {} need to be the special field code braces that you can insert using ctrl-F9) Peter Jamieson http://tips.pjmsn.me.uk On 21/01/2010 12:24, cyberdude wrote: Hi, I have two tables, table1 and table2. I want to write a formula to calculate the sum of element at cell a1 of table1 and the element at cell a1 of table2. So, 1.) What is the formula for doing this? 2.)What is the formula for just displaying the element at cell a1 of table1? 3.)What is the formula of dividing the element at cell a1 of table1 by the element at cell a1 of table2? Thank you |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dividing | Tables | |||
Dividing a page | Microsoft Word Help | |||
Dividing pages | Page Layout | |||
paragraph dividing | Microsoft Word Help | |||
dividing a document | Microsoft Word Help |