Getting Sums of Values

[Guest]

I have an Excel Worksheet in which I want to set up a drop-down list with a
list of data to choose from.

Example:
1 to 3 hours
3 to 5 hours
5 to 7 hours
7 to 10 hours

Since one of my jobs at work is to build online courses for our school
system, I would need this data for each course that I build.

I know how to set up the drop-down list in my Worksheet. However, is there
a function I can create (based on the drop-down lists) that could tell me how
many courses have, for example, "3 to 5 hours" selected from the drop-down or
how many courses have "5 to 7 hours" selected from the drop-down list? I
would like to eliminate having to manually couting the # of times a certain
selection appears since this Worksheet has several hundred rows (containing
individual courses).

 

[Guest]

How do you have your drop down lists set up, data->validation? You should be
able to use COUNTIF() for your range of drop down lists just like you would
with regular cells.
=COUNTIF(A1:A100,"3 to 5 hours")

 

[Guest]

That is exactly what I needed. Thank you, Dave!