Do you mean count the number of cells with DS in them?

If DS is in the cell by itself:
=countif(a1:a10,"DS")

if DS is in the cell with other stuff:
=countif(A1:a10,"*DS*")
or
=countif(A1:a10,"*" & "DS" & "*")
or
=countif(A1:a10,"*" & b1 & "*")
(if B1 containd DS)

Similar formulas for SM


Katy wrote:

How do i create a formula that will add all cells with the word DS in it then
a seperate formula that will add all the cells with the word SM in it and so
on

--

Dave Peterson