Hi

Try
=SUMPRODUCT(--(ISNUMBER(FIND("DO",A1:A100))))
Change range to suit

It might be better to put the "DO" or "DI" in a cell e.g. in C1 , then you
can just use the formula
=SUMPRODUCT(--(ISNUMBER(FIND(C1,A1:A100))))


--
Regards
Roger Govier

"Nanou" wrote in message
...
Here is a sample of my column cells contents:

2DO, 5DI (this data is in one cell)
1DO, 2DI
AI
AO

I need to get a total of "DO", total of "DI" ...etc. separately
I have tried countif, sumproduct...but not getting the right result!

Would appreciate any help.
Yasmina