creating formulas

K

Kniery

I am trying to create a formula where I can add subtotals from different tables together for a total. i.e., page one has a small table with a subtotal, then some text and on page two I have another table with a subtotal. What formula would I use to add together these two totals from different tables?
 
K

Kniery

nevermind, i figured it out. i was going under table in the menu and entering the formula. the way i got it to work was i went under insert in the menu and went to the field menu and typed the entire formula in. it now works and my boss loves me! thank you for helping me.
 
M

macropod

Hi Kniery,

Your formula looks OK and, when I tried it, works correctly.

Cheers


Kniery said:
Macropod,
the link you placed was very, very, very helpful, however, i tried the
equation and i am still getting a snytax error. here is the equation, what
am i doing wrong? {=SUM(Table8 b32)+SUM(Table9 b16)+SUM(Table9 b31)+B29}
i am referencing three different tables, the current one i'm in (+b29) and
two other tables (table8 and table9) which i selected the entire table and
inserted a bookmark calling these two tables table8 and table9.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top