Find part of a word then sumif the adjacent column

[Lizard07]

I would like to sum up one column if the adjacent column contains the word "Deliver". The entries vary, so all I want it to locate is "Deliver" then add up the number in the column next to it

Column D contains the numbers I want to sum
Column E is where I want excel to find the word "Deliver" then match to column D.

All of the data is located in the sheet named "Master".

Any help/tips would be much appreciated, thanks!

 

[VoG]

Try

=SUMIF(E1:E100,"Deliver",D1:D100)

 

[Lizard07]

I used the F4 button to lock on the column numbers like this below

=SUMIF(Master!E$2:E$60000,"Deliver",Master!D$2:D$60000)

This worked ONLY if the cell contained exactly "Deliver", which is not what I want. I need it to sum it up if it contains the word "Deliver"

Is there a SEARCH function I could us?

 

[VoG]

Try

=SUMIF(Master!E$2:E$60000,"*Deliver*",Master!D$2:D$60000)

 

[Lizard07]

Awesome, thank-you