Hi,

Try this

=SUMPRODUCT(LEN(","&$C$5:$C$17&",")-LEN(SUBSTITUTE(","&$C$5:$C$17&",",","&C19&",",","& REPT("
",LEN(C19)-1)&",")))

C5:C17 is the column of numbers. In cell C19, type the number which you
want to count the occurrence of

--
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