How to copy formula pattern?

Hi guys,

See my spreadsheet attached.

I wish to apply a sum of counting a week's worth of data to cells going down, per week. Is there an easy way I can get excel to copy the formula pattern i.e. =SUM(C2:C8), c9:c15, c16:22, etc.?

I am trying to enter the formula in cell I7, and then I8, I9 and so on.

Thank you.

I showed you how to do this in your previous thread:

Excel 2016 (Windows) 32 bit

	H	I	J
4	Week 1	=SUMIF($A$2:$A$23,H4,$C$2:$C$23)	=SUMIF($A$2:$A$23,H4,$D$2:$D$23)

Sheet: Sheet1

Enter once and then drag copy down. You can make the ranges as long as you need.

I have done it for you in the attached.

Sorry Ali - I missed that! thanks again

i4=SUM(OFFSET(C$2,ROWS(I$4:I4)*7-7,,7,))
or
i4=SUMIF($A$2:$A$23,$H4,C$2:C$23)
Try this and copy across

No need for a volatile OFFSET formula here!!!