This worked for me =SUMPRODUCT(--(ISNUMBER(FIND("dog",B1:B4))),D1:D4)
In B I had text such as "dog sat", "need a dog",
Any use to you?
For explanation see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Roger" wrote in message
...
What formula do I use to get a sum for all values from collum "D" only if
there is a particular word (out of a few words)in columm "B" of the same
row?