View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CP CP is offline
external usenet poster
 
Posts: 64
Default totaling data from a drop down list

Using Excel 2007, I have created a survey and some cells have drop down list.
For example, the responses include items such as private practice, physician
owned practice, free clinic, etc. After all the data is entered, I need to
calculate the number times each response was selected. Is there a way to do
this

Thanks for your assistance.