sum formula and vlookup formula

Column A Column B Column D Column E Column F Column G
Bob Test Bob Test 10 Bob Test 15
Test Test Test Test 10 Fred Bob 12
Fred Bob


Column A Column B
Basically i am trying to add the figure from column E and G together so in column B I want it to show: Bob Test 25
Test Test 10
Fred Bob 12

Please help.