Try:

=SUMIF(B1:B100,"your word",D1:D100)

HTH
Jean-Guy

"Roger" wrote:

What formula do I use to get a sum for all values from collum "D" only if
there is a particular word in columm "B" of the same row?