bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Fields > Adding a Dynamic Total in Your Document

Adding a Dynamic Total in Your Document

Summary: You can use a few bookmarks and an equation field to add a dynamic total anywhere in your document. Once in place, you can change any of the amounts, and the total is updated the next time the field results are updated. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

You can use Word to easily create a document that dynamically reflects changing values. For instance, you may have a document in which you have several figures mentioned. This might be a collections statement you are sending to a customer. Later you need to total these figures so you can show a total amount due. You can use bookmarks and a field to calculate the total due automatically. This is done in the following manner:

  1. Select the first amount that you want included in the total.
  2. Assign a bookmark to the selected amount; give it a name such as Amount1.
  3. Repeat steps 1 and 2 for each of the other amounts in your document, providing different bookmark names each time.
  4. Position the insertion point where you want the total inserted.
  5. Press Ctrl+F9 to insert a pair of field braces. Make sure the insertion point stays between the braces.
  6. Type =Amount1 + Amount2 + Amount3, and so on, where these are bookmark names. Make sure you include the names of all the bookmarks you defined and that you want included in the total.
  7. Press F9 to update the field.

Now, any time you change the amounts that you bookmarked, the field you inserted in step 6 will automatically be updated to the correct total. (You may need to print the document to update the fields, or you may need to select the field and press F9.)

You should note that this technique will not work properly if the amounts are formatted. For instance, if the amounts you want to sum include dollar signs and commas, then these will interfere with getting a valid sum with your formula.

Tip #1342 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007


Save Time! You can have this tip (and several hundred just like it) in the WordTips annual archives. Imagine having over 400 tips available at your fingertips, in each annual volume.

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home
Vital News Home

WordTips FAQ
WordTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)