¨ FrontPage ¨ Outlook ¨
¨ Miscellaneous ¨
First, I'd like to say that I don't recommend that you do this if:
Yes, it can be done without the three items above...I just don't recommend it.
Hit ViewŕToolbars and choose the Forms toolbar.
Open a new, blank document in Word and insert a 2-column, 4-row table. Note that Word, like Excel assigns the cells, as shown (no, your table won't have numbers in it).
In B1 through B3, insert one text form field into each of the cells.
Double-click each field, and check the Calculate on Exit checkbox. Note that each one's Bookmark name increases by one, as Text1, Text2...
In B4, hit InsertŕField, choose Equations and Formulas from the Categories drop-down, then choose Formula from the Fields list.
Hit the Formula button, and write your formula. You could type =SUM(A1:A3), but I want to make you aware of the quicker way, which is =SUM(Above), which will sum all the values in the table above the formula. Do not expect to be able to use this method in multiple tables. Hit OK.
Protect the form using the padlock icon on the Forms toolbar. Enter some values in B1, B2, and B3, and as you enter each one, the value in B4 will increase (because we checked Calculate on Exit—if we hadn't, we wouldn't see it update automatically like that—we'd have to use some other method to update the field.
You can use the same methods above. Suppose you have created a proposal, and used dollar values throughout your document. As long as those values are assigned to bookmarks, you can use a formula as simple as:
When you use bookmarks, users often accidentally delete them.
When you are calculating in Word tables, you should really try to start with freshly created tables on which you haven't been merging and splitting cells. This causes the "cell references" to break, and it's very difficult to learn what the cell references are once this has been done.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved