totaling data from a drop down list

C

cp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Truncating data in drop down list 6
Drop Down List - Select Multiple Items 12
Drop Down List Unavailable 1
SUM determined by drop-down list 9
Connecting drop down list selection to data 3
data validation drop down list format 1
Excel 2003-Data Validation drop down list not working? 2

Top