Summing cells fr multiple tables in Word 97

[Bob]

Hey Peoples:
I am using using Word 97. I have a single document that
has multiple tables, each of which sums (ABOVE) no
problem. I need to sum these sub-totals in the final
table. Tables are bookmarked Table1 Table2 etc so that my
formula in final table is ~ "SUM(Table1 b5,Table2 b7,
Table3 b6, Table4 b5)" which is how the syntax is given in
the Help menu. I am getting a "!Syntax Error, )" and
sometimes a "!Undefined Bookmark, TABLE1B7" when I change
a cell value and try to re-calculate using F9. I notice
that the formula's syntax has been changed to eliminat
spaces between table and cell references. Any good advice
appreciated. Any particular questions will be answered
promptly!
Thank you, Bob

 

[Suzanne S. Barnhill]

The Help examples don't include any that have more than one cell reference
in a SUM field. What happens if you try { = (Table1 B5) + (Table2 B7) +
(Table3 B6) + (Table4 B5) } ? Failing that, you could assign specific
bookmarks to the relevant cells.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[macropod]

Hi Bob,

Something along the lines of:
{={=SUM(Table1 B5)}+{=SUM(Table2 B7)}+{=SUM(Table3 b6)}+
{=SUM(Table4 b5)}}
should work.

Cheers
PS: Remove NO.SPAM from the above before replying.

 

[Bob]

I kept getting syntax errors with those elaborate
formulas, so I bookmarked the individual cells per you
suggestion, and they sum up right. I can't see that there
are any disadvantages to this approach in this situation.
Thanks a lot!
B.

 

[macropod]

Hi Suzanne,

I agree. What's worse, is that there's no way of
referencing text entries (including dates) in a table
other than by bookmarking them individually. You can't,
for example use an IF test along the lines of:
=IF(A1="30 June 2003","Goodbye","Hello")
because any text in A1 will evaluate to 0, except dates -
which give weird results (note: I'm not using the correct
syntax).

Equally poor is Word's handling of IF statements where a
text output is required. Excel syntax is fine for numeric
output, but you need a completely different syntax for
text output.

Cheers
PS: Remove NO.SPAM from the above before replying.