Suming or dividing elements from different tables

  • Thread starter Thread starter cyberdude
  • Start date Start date
C

cyberdude

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
 
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?
Click to expand...

Sorry that I missed one thing. All the formulae above are to be
embedded in a cell of table 3. Thank you.
 
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
 
Back
Top