Try this in C2, and autofill down:

=SUM(INDEX($B$2:$B$500,(ROW()-2)*8+1,1):INDEX($B$2:$B$500,(ROW()-2)*8+8,1))
Cheers,