Summing cells fr multiple tables in Word 97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 25 Aug 2003 20:12 GMT

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

Reply to this Message

Suzanne S. Barnhill - 25 Aug 2003 23:27 GMT

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)

Signature

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.

> Hey Peoples:
> I am using using Word 97. I have a single document that
[quoted text clipped - 11 lines]
> promptly!
> Thank you, Bob

Reply to this Message

macropod - 26 Aug 2003 11:53 GMT

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.

>-----Original Message-----
>The Help examples don't include any that have more than one cell reference
[quoted text clipped - 27 lines]
>
>.

Reply to this Message