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.

 

[Fluff]

How about in B3 dragged down

=SUM(INDEX(T!B:B,ROWS(B$3:B3)*7-5):INDEX(T!B:B,ROWS(B$3:B3)*7+1))

 

[Hmill]

That works for the first row but just get 0's after that

 

[Fluff]

From your image there is nothing but zeros in your data.

 

[Hmill]

Oh, your right. I haven't updated that data yet. Thanks

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Hmill]

Hey bro, I got all my data inputted and the formula doesn't work.

 

[Fluff]

In what way?

 

[Hmill]

This what its giving me:

This the data its supposed to be pulling from.

This is my data

 

[Fluff]

Check the your numbers are real numbers & not text.