One way (assuming only one entry per cell):

With the desired value in A1, and the list in Data!D:D:

=COUNTIF(DATA!D:D,A1&",*") + COUNTIF(DATA!D:D,"*," & A1 & ",*") +
COUNTIF(DATA!D:D, "*," & A1) + COUNTIF(DATA!D:D,A1)



In article ,
porter444 wrote:

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