See if this helps you:
http://www.contextures.com/xlDataVal13.html

or this:
http://www.contextures.com/xlautofilter02.html

or this:
http://www.contextures.com/xlautofilter02.html#Count


Regards,
Ryan---


--
RyGuy


"ggoldber" wrote:

Want to count a selection from a drop down menu every time it is selected and
have the sum of the "hits" appear in another cell. Cannot figure out
formula. Help would be appreciated.

Thanks

Jerry