Macro / code to sum by different criteria

[lilmisstexas]

Hope that the title made sense guys, and hello!

I have a sheet where users enter time spent on projects. I need the sum of those hours, based on week-ending, name of project and person.

Ideally, I wanted a drop down box one could pick that would populate the desired data, but to be honest, at this point I'd settle on just getting the numbers somewhere in the sheet.

-------------------

EDIT: Okay, I absolutely know I must be going the long way around this, but I have a formula in to at least calculate time for week-ending - new sheet attached. I am now trying to add a list?/combo? box where another manager can select a WE Date, and the total for that week pops up. I am totally new at combo / list boxes though.