I'm not sure I understand what you want but have you looked in the help
index for COUNTIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"porter444" wrote in message
...
Gurus,

Hope you can help me out once again. You guys/gals ROCK!

I have a worksheet that contains survey results and in one column there
are
the results of a ranking exercise. The survey respondant enters a list of
numbers that correspond to the 15 most critical items from a list of 50
items. Each item is designated by a number between 1 - 50.

The entry looks like 1,4,6,18,19,23,44,50...

On another worksheet I need to summarize how many times each of the 50
items
makes it into a top 15 response.

In other words I need to be able to count how many times 1 appears in
column
D (not 10,11,12,21,31,41...ect.).

My struggle here is coming up with a way to count if the range contains a
specific value, and then how to exclude non-matches like 10,11,12... etc.

Any help you can provide would be AWESOME.

Thanks,

Scott