Is there an error in this?
Yes.

Try:

=SUM(INDIRECT("Sheet1!$C" & (ROW(D17)-17)*7+6 &" :$BB"& (ROW(D17)-17)*7+12))

Regards, TMS