excel 2007

K

Katy

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
 
D

Dave Peterson

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
 
R

Ragdyer

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".
 
Top