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

  • Thread starter Thread starter gh
  • Start date Start date
G

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?
 
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
 
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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top