sumif and moving date ranges

[jontyoc]

Hi All

Hoping I can explain this fully and someone can help me.
I have a weekly report that I use to sum up the hours agents work to report back to them. The amount of agents has since doubled and I can no longer manually check.
What I want to do is sum the hours the agents work from the report and give it in a weekly format:

Sheet 1 shows the agents name and their running weekly totals. This is where the formula will be.
Sheet 2 will be the raw data and will run from 4/1/16 to 31/12 eventually.

I was thinking =SUMIF(Sheet2!a$3:m53,A5,Sheet2!b$3:f$53)
but instead of summing 3 lots of 8.5 to give 25.5 this gives me 7.5!

4/1 5/1 6/1 7/1 8/1 11/1 12/1
Abby 8.5 0 8.5 0 8.5 8.5 7.5
Brian 0 8.5 0 8.5 8.5 7.5 8.5

Sorry I couldn't upload the table as at work at the moment and our firewall is a pain!

What I want it to do is sum each Monday - Friday date and give me a final figure on sheet 1.

What am I doing wrong or can you put me right please?

Thanks.

 

[Trevor G]

Have you tried using a Pivot table for this?

 

[jontyoc]

The raw data comes from a pivot table in days but I need to send email out with weekly hours worked.
So need to sum it to get correct information.