Vlookup,IF? List box formulas!

Hi, think I took a little more than I could handle to from the boss, spent a little too much time on it so...
I've created a sheet that contains many different list boxes. When chosen values are entered next to them. I want to create a table with all the list values (text) that display the total value for that particular option. Ive tried Vlookup & IF can seem to get the right formula.

Please see sample worksheet attached!

Book2.xlsx

I did Joe Bloggs for you

what you want is =sumif()

for example in N3=SUMIF($D$5:$D$7,M3,$E$5:$E$7)+SUMIF($F$5:$F$7,M3,$G$5:$G$7)+SUMIF($H$5:$H$7,M3,$I$5:$I$7)+SUMIF($J$5:$J$7,M3,$K$5:$K$7) will add up all the IT for Joe Bloggs
then you can copy the formula down you will need to change the ranges for Mrs Bloggs

Thanks for the reply, so if i was to add "Mrs Bloggs" in to the same it formula bring the combine IT?

yes, it will be a long formula though, i would suggest doing it in 2 steps
keep the Joe Bloggs as is and do the same for Mrs Bloggs, then for the grand total do N3+R3 where R3 is the formula for Mrs Bloggs (or where ever it is located) this way it is easier to locate a mistake otherwise it would be a formula double the length