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

[URL="http://tips.pjmsn.me.uk"]http://tips.pjmsn.me.uk[/URL]

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
 >> Stay informed about: Suming or dividing elements from different tables