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

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