Thread: drop down list and adding numeric values to text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default drop down list and adding numeric values to text
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.

Reply With QuoteReply With Quote