SUMIF and Compounding formula

Hi    I have the below dataset, what im looking to do is to say:   Rounddown(Week 02 + Week 01,0) i.e 1,022.27 -15.48 = 1,006 Then moving the forumla needs to flow each week so:   1,022.27 - 1...