Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Auto Sum Number Form Fields in Word Table
Does anyone know how to create a SUM ABOVE function in a table so when the
form is protected and the number fields are completed, the numbers in the column above the function are automatically totalled? I've inserted a Text Form Field in each cell with number properties and bookmarked NUM1, NUM2, etc. In the cell where I want the sum to appear, I've tried inserting a blank expression field {=NUM1+NUM2 \ #,###} as well as Text Form Field with Calculate property and same formula, but the result is always !SYNTAX Error. Any ideas out there? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Auto Sum Number Form Fields in Word Table
The problem is with your formatting switch, which should be \# #,### (or
better \# ,# ) You can just use a { =Sum(Above) \# ,# } formula in the location where you want the total to appear and check the Calculate on Exit box for each of the formfields that will contribute to the result -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Schuuch" wrote in message ... Does anyone know how to create a SUM ABOVE function in a table so when the form is protected and the number fields are completed, the numbers in the column above the function are automatically totalled? I've inserted a Text Form Field in each cell with number properties and bookmarked NUM1, NUM2, etc. In the cell where I want the sum to appear, I've tried inserting a blank expression field {=NUM1+NUM2 \ #,###} as well as Text Form Field with Calculate property and same formula, but the result is always !SYNTAX Error. Any ideas out there? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-incrementing number fields in Word Forms | Microsoft Word Help | |||
Auto Updating Fields from a Word Table | Tables | |||
Auto fill Form Fields from previous Variable fields? | Microsoft Word Help | |||
How do I set up an auto number on a Word Form? | Microsoft Word Help | |||
Auto-entry of defined Form fields in Word 2003 | Tables |