["vba"] Sum 3 days of work per person

[montecarlo2012]

Hi,
I am trying to figure out how to coding a total sales by person, I just upload 3 days info.
what I have now and where :

as you see for example Derek total per day, I would like the same for the rest.
I can think about the pseudocode (maybe) like this

start

On I3:I10 if B2:B33 names match H3:H10 then
Sum(offset , c,d,e,)

On J3:J10 if B2:B33 names match H3:H10 then
Sum(offset , c,d,e,)

On k3:k10 if B2:B33 names match H3:H10 then
Sum(offset , c,d,e,)

End

what I was reading in different website is more or less how to use sum and offset, but honestly I didn't figure out, so here I am. Please give a hand here.
Thanks

 

[montecarlo2012]

I did, also for some temporary files, clean dns, etc. everything is fine. thanks

 

[ebea]

I did, also for some temporary files, clean dns, etc. everything is fine. thanks