Add hours from one column based on a result in another column

I familiar with using IF statements in Excel but I'm having trouble coming up with the correct formula for this one. It might not be an IF statement that I need.

For my web design company, I am doing an internal schedule to show who is working on what projects at any time. The whole goal of this is then to be able to look at the bottom of the workbook and see how many hours are scheduled for each employee at a time. So my column E is my resource name (employee) then column G starts on dates, so G is week of 8/24, H is 8/31, I is 9/7 etc. So at the bottom I want to be able to go the whole way down column G and check to see where a certain employees name is entered and if it is entered then go over to column G and add up all lines in that column (number of hours for that project) where the employees name is entered.

I've attached the workbook for reference.

Welcome to the forum.

Please take a few minutes to read the forum ruules, and then amend your thread title accordingly.

Thanks.