PC Review


Reply
Thread Tools Rate Thread

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

 
 
gh
Guest
Posts: n/a
 
      18th May 2010
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?
 
Reply With Quote
 
 
 
 
Doug Robbins - Word MVP
Guest
Posts: n/a
 
      18th May 2010
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" <(E-Mail Removed)> wrote in message
news:C555AAED-1BA0-469C-A7BE-(E-Mail Removed)...
> 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?


 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      19th May 2010
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" <(E-Mail Removed)> wrote in message
news:C555AAED-1BA0-469C-A7BE-(E-Mail Removed)...
>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?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop dwn menu. Formula to count selection frm menu in anoth cell? ggoldber Microsoft Excel Worksheet Functions 1 4th Jun 2008 02:21 PM
How do I enter more than 25 items in a drop down menu box? =?Utf-8?B?Q0pheQ==?= Microsoft Word Document Management 1 6th Jul 2005 08:32 PM
Applying a formula to a drop menu choice =?Utf-8?B?QW5kcmV3IEhpbGw=?= Microsoft Excel Misc 1 4th Jan 2005 11:05 AM
Create a drop down menu response to link another drop down menu? Nicholas Microsoft Frontpage 0 1st Sep 2004 05:31 PM
Re: Create a drop down menu response to link another drop down menu? Don Microsoft Frontpage 0 1st Sep 2004 04:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:06 PM.