Consider using AutoFiter:

Data Filter Autofilter Custom... Contains SP

This will hide all entries that do not contain SP. Finally use the
=SUBTOTAL() function to count the visible cells.

If the items in cells were separated by commas, then a macro could be
written to produce a complete tally for each individual code.

--
Gary''s Student - gsnu2007k


" wrote:

I don't know if this is possible. I have a column that I enter
different chars. i.e. 1, d,hd,au,ad,L, SP, P. These are entered on
their own. But I need to be able to enter two different items in one
cell. Everything gets counted. Now, what I want to try and do is this.
If I enter a 1 and P in the same cell, can I get it to count the 1 and
the P seperately and put the total in different cells? I could have a
large number of entries in 1 column of any combinations and each need
to be counted on their own merit. I don't have enough columns to be
able to use 1 column for each char. Or, if this can't be done, is
there any way I can get round this?
Your wise advice would be appreciated.
Bryan.