Discussion:
How to insert formula on a fill in form that adds columns
(too old to reply)
ettadanreb
2010-03-26 14:23:01 UTC
Permalink
I set up my fill in form as a table. The user types the numbers in the
columns. I need the columns to add at the bottom of the column and give me a
total.
macropod
2010-03-26 15:00:43 UTC
Permalink
Hi ettadanreb,

On the 'totals' row for the column concerned, create a formula field by pressing Ctrl-F9. You should see a pair of field braces (ie
'{ }'). Between the field braces, type =SUM(ABOVE), so that you end up with '{=SUM(ABOVE)}'. Then, with the properties of each
formfield that contributes to the total, ensure the:
. data type is set to number, with the appropriate format;
. default value is set to whatever you want it to be (not empty); and
. 'calculate on exit' option is checked.
When you're done, protect the form.
--
Cheers
macropod
[Microsoft MVP - Word]
Post by ettadanreb
I set up my fill in form as a table. The user types the numbers in the
columns. I need the columns to add at the bottom of the column and give me a
total.
Loading...