Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
ettadanreb ettadanreb is offline
external usenet poster
 
Posts: 1
Default How to insert formula on a fill in form that adds columns

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.
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default How to insert formula on a fill in form that adds columns

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]


"ettadanreb" wrote in message news
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.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a formula in a Word table that adds cell values? Adrian Sark Microsoft Word Help 2 December 10th 08 06:28 AM
Insert crossreference para number adds previous level Jim Tortorelli Microsoft Word Help 3 March 16th 07 09:34 AM
Word automatically adds columns when I open it. w1ll3rd Microsoft Word Help 2 September 12th 06 05:03 AM
Merge in Word adds labels between columns JadedGemini Mailmerge 6 May 26th 06 06:13 PM
formula to calculate form fill-in fields Gib Microsoft Word Help 1 February 5th 05 05:59 AM


All times are GMT +1. The time now is 02:09 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"