Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |