How to have a calculation shift down 7 cells per 1 result cell.

[Hmill]

I am trying to do a summation of how many labs occur per week from a daily count on another sheet. However, I can not get the summation to shift down 7 days at a time. Is there a way to do this?
Weekly summary:

From the Daily Counts:

I need It to sum a week at a time like this. Then , the next cell automatically sums the range for the next week, not just shift the range down one cell.

 

[Hmill]

They are.
It used to work, but know if I reset those cells they all show zero.

 

[Fluff]

In that case can you upload your workbook to a share site such as OneDrive, GoogleDrive then mark for sharing & post the link you are given to the thread.

 

[Hmill]

Yes, but I'll have to wait till lunch. I can't access filesharing sites from work so I'll use my phone to do it during lunch.