Looking for a formula please.

I have in Col D pairs of names in each cell and in Col E some numbers in each cell. I need to create a NEW column counting the amount of times a partial name appears in Col D and then add the number from Col E associated with it minus 1.

example: Count how many times "Bob" appears in Col D then on each row in Col D that has a "Bob" total the numbers in Col E then subtract 1

So the answer to the example above should read 10. Bob=2(from D) +5+3(from E)-1

COL D COL E
Bob Champ & Julie Foxx 5
Vic Black & Geoff Goode 2
John White & Bob Champ 3