Probably the best bet would be...

....to see Biff's reply! <grin

--
Biff
Microsoft Excel MVP


"Bob Umlas" wrote in message
...
=SUMPRODUCT(N(NOT(ISERROR(FIND(9,R11:R281)))))
will work, but it will also count 9's found in 19, 29,793, etc.
You might toy with the formula and search for "9," but that would found
29,
or you might try " 9," but that would not find a leading 9 or just a 9.
So clearly, it's not trivial.
Probably the best bet would be a user-defined function.

Bob Umlas

"watermt" wrote in message
...
Using Excel 2003:
I'm trying to use the =COUNTIF function to count the number of
occurrences a
number appears (numbers 1 through 43) in cells within a column. Each
cell
can contain only one number or multiple numbers with no duplicates per
cell.

Here the formula:
=COUNTIF(Apr_09!R11:R281,"=9")

eg. cell R22 contains 2, 9, 34, 22, 10; cell R14 contains 1, 9, 33, 20,
15;
cell R30 contains 1, 9, 16, 27

I need a COUNT formula similar as above to look at the entire Range
(R11:R281) and count the number of time the number 9 appears in a cell.
There can never be more than one instance of a number in each cell (i.e.,
number 9 cannot appear in cell R30 more than once).

Any help is greatly appreciated,
Mike