Help Please For Formula Copy Skipping Cells?

That is the interval but the *31 number remains the same and it doesnt evaluate the 27 row jump.

I've attached a sample file, it's lost some formatting but I hope you can see what I'm trying to achieve on the summary page.

Thanks for your help with this!