I have a sheet with information like the following
2013-08-14_12h39_56.png

And wish to create a summary sheet in like so

2013-08-14_12h41_10.png




And I need to write a formula that will lookup values in row 3 on sheet 1 based on the name in column A of sheet 2 and give me a sum of the values beneath it for every occurrence of it. In this example bob appears twice so we need to find the total for both columns.

Sheet1 will be for one month only and a new sheet will be incorporated for any new month.

I have got lost in sumifs and sumif's and now my brain has exploded so any help appreciated.