[Penstemon]

I'd like to use quick Parts fields to write a formula that adds subtotals
from 4 different pages. I tried bookmarking each of the numbers but got a
syntax error.
Here's what I tried:
=SUM([sum1a]+[sum1b]+[sum1b]+[sum1c]+[sum1d])

[macropod[_2_]]

Hi Penstemon,

At its simplest all you need is a formula field expressed as:
{=BkMk1+BkMk2+BkMk3+BkMk4}
where BkMk# is a value's bookmark name.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"Penstemon" wrote in message ...
I'd like to use quick Parts fields to write a formula that adds subtotals
from 4 different pages. I tried bookmarking each of the numbers but got a
syntax error.
Here's what I tried:
=SUM([sum1a]+[sum1b]+[sum1b]+[sum1c]+[sum1d])