You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tim JA" wrote in message
...
Thank you.. you were right it does work!!! I intially copied the formula
wrong. Thanks again.

"Ashish Mathur" wrote:

Hi,

That is exactly what my formula does. I have tried it. It will search
for
all occurrences of 2 in the range above (whether appearing in the cell
alone
or along with some other number). If there is more than 1 number in one
cell, the numbers have to be segregated by commas (as shown in your
initial
post)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tim JA" wrote in message
...
The formula you provided works for cells containing a single number.
How
can
I get it to include a specific number in cells with multiple numbers as
well?
For example, if I wanted occurrences for the number 2... there's a
cell
with
just that number by itself and another cell that has both 2 and 6. In
this
case, the formula should come up with 2 occurrences...

"Ashish Mathur" wrote:

Hi,

Actually the simplest approach would be to use text to columns to
segregate
numbers in different columns and then use the countif

=countif(A3:F50,A55)
--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tim JA" <Tim wrote in message
...
I'm using office 2007, specifically excel. I cannot get the countif
function
to accurately count cells containing multiple numbers. For example
below
is a
column containing both single and multiple numbers. I'm trying to
get a
count
based on any number in the column. Perhaps, I'm using the wrong
count
function. I've tried using wild cards... but to no avail. Your help
would
be
greatly appreciated.



5
9
2,6
2
3,6
6,7
5,13
2

6

1,10,13
13

.