Auto-updating basic math functions & cross-referencing tables

[FranklinBluth]

I'm creating a form in Word where scores have to be tallied in multiple categories across nearly 15 pages. I'd like to set everything up so that the sums are calculated automatically but am having a few problems, as I've never used math functions in Word before:

1. When I use the basic "=SUM(A1:A15)" function, it does not automatically update the output if I input a new number in one of the affected cells. Excel performs this function dynamically, is there a way to do it in Word? Only option I see is manually right-clicking the formula and selecting "Update Field."

2. The first page of the document is a "Master Tally Sheet" that tracks results from all of the following pages. How do I reference the outputs from tables on these other pages? I only know how to get a formula to recognize data within a single table.



Attached is a sample document (just the first two pages, but you'll get the idea). The subtotal on every page has to be automatically feed back to page 1 - the Master Tally Sheet.

Thanks!

[DMD]

I am trying to do something similar to your post, but simpler.
Did you ever find a solution for the problem? Thanks

[DMD]

I just noticed we have very different systems

[FranklinBluth]

Nope. Never got a response and it wasn't crucial for work purposes so I forgot about it.

[DMD]

Originally Posted by FranklinBluth

Nope. Never got a response and it wasn't crucial for work purposes so I forgot about it.

Thank you very much for your reply.

[FranklinBluth]

So I did some more quick Google-ing and I think I got it now...

1. Create a table in Word - the cells are identified the same as they are in Excel, Word just won't show it explicitly (A1, A2, B1, B2, etc.)

2. Use the Text Form Field to insert fields where your numbers will go. Make sure you select "Calculate on Exit" in the Form Field Options for each one. This allows auto-calculations to occur where you will have your function.

3. Table-->Formula or Insert-->Field-->Formula in the cell where you want your final calculation to be done.

Full tutorial here

This only works within single tables, not across multiple tables, which still doesn't completely solve my problem.

[DMD]

Originally Posted by FranklinBluth

So I did some more quick Google-ing and I think I got it now...

1. Create a table in Word - the cells are identified the same as they are in Excel, Word just won't show it explicitly (A1, A2, B1, B2, etc.)

2. Use the Text Form Field to insert fields where your numbers will go. Make sure you select "Calculate on Exit" in the Form Field Options for each one. This allows auto-calculations to occur where you will have your function.

3. Table-->Formula or Insert-->Field-->Formula in the cell where you want your final calculation to be done.

Full tutorial here

This only works within single tables, not across multiple tables, which still doesn't completely solve my problem.

First: Thank you for taking the effort to find more info. I am only using
a single table, but apparently the options for Word 2003 are different
from 2007. I don't have the "field" or "formula" options. When I try
"equation" and put =sum(above) in the cell where I want my total;
those very words and symbols stay in the cell and there is no math
calculation. I tried enter numbers in the cells above, but no total
appeared? Thanks again

[FranklinBluth]

That tutorial briefly mentions the use of bookmarks as well, which is necessary for calculating across multiple tables in a single document.

Highlight the field you want to be bookmarked and go to Insert --> Bookmark. Name the bookmark something obvious. Then if you want this field to reappear somewhere else in the document (in another table) you can just do the formula "=bookmarkname" and you're set!

Hope that helps