Thread: SUM based on Date Range and Additional Integer

I have a tab, "Weekly Time," that contains all time information for a project and corresponding variables. In another tab "Time Per Sales" I need to have the total time computed based on a Salespersons name within the time frame specified in row 3; there is a column for Week, Month, Quarter, and Year in which you would entire desired time frame and the Total Hours Worked should total.

I have created dynamic ranges and lists as well as a calendar that corresponds date ranges based on year and ISO week numbers, but this last piece of the puzzle I cant get to work.

Here is the link to the uploaded file.

http://www.excelforum.com/attachment...1&d=1315334183http://www.excelforum.com/attachment...1&d=1315334183

I hope I am being clear, please let me know if you need further clarification.