If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to write a formula to add numbers from separate pages (Word)
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]) |
#2
|
|||
|
|||
How to write a formula to add numbers from separate pages (Word)
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]) |
Thread Tools | |
Display Modes | |
|
|