I was tasked to add the total weekly tasks and monthly tasks. So initially, my idea is just to do this. SUM(J1:J5) Since that would actually total the weekly tasks, however, if I drag that down to autofill the columns, it would result to: SUM(J2:J6) It just adds 1 to continue the order, what I want is this: SUM(J7:J12)

Or, if there's any other way to do the adding up of weekly tasks and monthly tasks dynamically, please enlighten me.

Thank you.

CodePudding user response：

see:

=SUM(INDIRECT("J"&ROW(J1)*5 1-5&":J"&ROW(J1)*5))