Let's assume you have this data:

A1 = 1,5,10,11,21
A2 = 12,5,31,32,1
A3 = 1,7,10,21,39
A4 = 1,2,3,1,11

Number delimited by commas.

To count how many instances of the number 1...

C1 = 1

Array entered** :

=SUM(LEN(","&A$1:A$4&",")-LEN(SUBSTITUTE(","&A$1:A$4&",",","&C1&",","")))/LEN(","&C1&",")

Result = 5

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

That's very cryptic and may induce headaches if you stare at it too long!
<g

--
Biff
Microsoft Excel MVP


"watermt" wrote in message
...
I need to come up with a formula (e.g., COUNTIF, VLOOKUP) that will look at
each cell in a column and count the number of occurence for each number in
all cells in the column.

I'm not sure which formula to use or which 'seperator' (i.e., comma, dash,
etc.) to use within the cell. My numbers are inclusive of 1 through 43,
and
I do not want to count the number 1 as number 1 when it appears as 10, 11,
12, 21, 31, 41 and so on.

I thank you in advance for any and all assistance,
Mike