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 do I SUM/ADD Formulas and Form Texts in Word Tables?
I have a table in a Word Form. I want to Sum 3 Cells in a Column.
One of the Cells was inserted using 'InsertField' (g6). This Cell has a formula summing the 4 cells above it (g2:g5). The other 2 cells I would like to add to it are {FORMTEXT} cells (g7,g8). When I put the following formula in it does not update.....=SUM(g6:g8)\#"$#,##0.00;($#,##0.00)"} I've tried clicking the 'Update' icon in my toolbar. I've checked that the {FORMTEXT} cells have the 'Calculate on Exit' checked off. I've already published these forms in my company. I need to fix this problem Thanks...Stacey |
#2
|
|||
|
|||
How do I SUM/ADD Formulas and Form Texts in Word Tables?
Hi Stacey,
In the cell where you want the SUM to appear: .. press Ctrl-F9 to create a field, which will look like '{ }' .. between the braces, type '=SUM(g6:g8) \# $,0.00;($,0.00) .. make sure each of the formfields in the other cells are set to 'Calculate on Exit'. .. lock the form Your formula should now update if the values in any of cells g6:g8 are changed. Cheers "Stacey" wrote in message news I have a table in a Word Form. I want to Sum 3 Cells in a Column. One of the Cells was inserted using 'InsertField' (g6). This Cell has a formula summing the 4 cells above it (g2:g5). The other 2 cells I would like to add to it are {FORMTEXT} cells (g7,g8). When I put the following formula in it does not update.....=SUM(g6:g8)\#"$#,##0.00;($#,##0.00)"} I've tried clicking the 'Update' icon in my toolbar. I've checked that the {FORMTEXT} cells have the 'Calculate on Exit' checked off. I've already published these forms in my company. I need to fix this problem Thanks...Stacey |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding formulas to tables | [email protected] | General Discussion | 1 | November 3rd, 2005 03:12 PM |
Word 97 in Windows XP to maintain formatting | Charlie''s Word VBA questions | General Discussion | 21 | October 24th, 2005 09:49 PM |
Excel should let me use formulas that refer to other cells w/ form | Chenopod | Worksheet Functions | 7 | May 31st, 2005 04:21 PM |
Formulas in Word | earlydawn | General Discussion | 1 | May 1st, 2005 05:04 PM |
Word and formulas | ANDREW MC | New Users | 2 | November 4th, 2004 09:29 PM |