View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
paul paul is offline
external usenet poster
 
Posts: 247
Default drop down list and adding numeric values to text

if you use a forms toolbar combo box the linked cell returns a number for the
choice ie if your list is yes ,no,maybe the linked cell will read 1,2,3
respetively.You can then sum acrooss the boxes.A vlookup table with values
assigned to yes no maybe with a vlookup formula for each dropdown will aslo
let ou summ across the boxes
--
paul

remove nospam for email addy!



"Dave O" wrote:

Could you possibly use the COUNTIF() function, and forego the
requirement of assigning a value to occurences of yes and no? This
would just count the number of "yes" occurences in the range you
specify.