Hm, I tried to make an adjustment by filling in the information to meet the criteria for my second question, but it is returning the wrong answer. Here is the formula I used:

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

Is there an error in this?