how can i enter a formula to tabulate the sum of drop down menu r.

[gh]

I am creating a checklist to rate proposals and am using dropdown menus with
values of one through four. I would like to be able to "sum" the responses
at the bottom of each section. Is this possible?

 

[Doug Robbins - Word MVP]

If you have another formfield in which you want the sum to be displayed, run
the following macro on exit from each of the dropdowns

With ActiveDocument
.FormFields("Sum").Result = .FormFields("Dropdown1").Result +
..FormFields("DropDown2").Result _
+ .FormFields("Dropdown3").Result + .FormFields("DropDown4").Result
End With
--
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

 

[Graham Mayor]

Given that each dropdown field has a bookmark name, you can check the
calculate on exit check box of each field and use a formula field to add the
values of the bookmarks eg

{ ={ REF Dropdown1} + { REF Dropdown2 } + { REF Dropdown3 }}

All brackets are entered with CTRL+F9
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>