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

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

Enter the "word" to *count* in say, B1, where the cells that contain the
words are in A1 to A100, and try this:

=Countif(A1:A100,B1)

When you change the contents of B1, the *count* will change to reflect the
new "word".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Katy" wrote in message
...
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

=SUMPRODUCT(--(A1:A100="DS"))

=SUMPRODUCT(--(A1:A100="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