SUM row & Reset when certain condition is met

[CASiddall]

Hi

I've got a list in which I need to sum values (including blank cells) in a row , until I insert a condition 'x' which resets the count. The columns go by Weeknum and day, and in a cell (at the end of a year) I need a formula which can calculate this, as per the example

CW-1 CW-2 CW-3 CW-4 CW-5 CW-6 CW-7 ..... CW-52 Total
Row 2: 4 blank 3 x 3 2 2 7


As from this example, the sum was 7, then was reset to start sum at zero after 'x' and is now currently 7.

Any ideas on the formula (or Macro) to use in the 'Total' Column?
Thanks

 

[FormR]

Also posted here.

https://www.mrexcel.com/forum/excel...-sum-restart-count-condition.html#post5181820

 

[Fluff]

Please do not post the same question multiple times. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).