how can i enter a formula to tabulate the sum of drop down menu r.
in [Document Management]
|
Prev: Embed Excel documnet into a word 2007 doc.
Next: How can I convert 2003 Word document into 2003 PowerPoint?
From: gh on 18 May 2010 16:50 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?
From: Doug Robbins - Word MVP on 18 May 2010 18:04 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 "gh" <gh(a)discussions.microsoft.com> wrote in message news:C555AAED-1BA0-469C-A7BE-73D319FEFC9F(a)microsoft.com... > 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?
From: Graham Mayor on 19 May 2010 01:14
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 Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "gh" <gh(a)discussions.microsoft.com> wrote in message news:C555AAED-1BA0-469C-A7BE-73D319FEFC9F(a)microsoft.com... >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? |