How to Sum data on constant 7 days with Offset Formula

[allenpee85]

Hi,

Tech guys, I have a question on how to constantly add in the 7 days data with conditions:

a) every new data will be summing up with 7 days condiiton
b) by using offset formula

Thank you.

*Please see the uploaded file.

 

[Jake Collins]

Dear allenpee85

I assume you want an offset formula to replace the formulas in cell O12.

One which would work is

=SUM(OFFSET(C1,0,0,7,1))

 

[allenpee85]

Thanks.

 

[allenpee85]

Dear allenpee85

I assume you want an offset formula to replace the formulas in cell O12.

One which would work is

=SUM(OFFSET(C1,0,0,7,1))

Thanks....