Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Help - creating forms and formulas in Word | Microsoft Word Help | |||
Help - creating forms and formulas in Word | Mailmerge | |||
Formulas in Word | Microsoft Word Help | |||
WORD TABLE FORMULAS Forms | Tables |