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.

Hi,

You could use the countif() function =countif(range,A10). Cell A10 contains
free clinic

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"cp" wrote in message
...
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.

Thanks, I have never made a survey on excel. I will give it a try

"Ashish Mathur" wrote:

Hi,

You could use the countif() function =countif(range,A10). Cell A10 contains
free clinic

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"cp" wrote in message
...
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.