I am looking for a little help here. I'm not a novice, but I am not an expert either. Just need to resolve one issue. I will include as much info as I can during my explanation.

I am trying to make a "days since" tracker that shows the days since someone has delivered a certain thing. (not using dates just week numbers).

I have most of a formula set up and ready to go just need to tweek it a little and I cannot figure it out.

in the final box, 0=7 and 1 resets the counter. Heres the formula;

=IFERROR(COUNTIF(INDEX(A4:BB4,LOOKUP(2,1/(C4:BB4=1),COLUMN(C4:BB4))):BB4,0)*7,COUNTIF(C4:BB4,0)*7)

I need to reset when it detects any number 1 and above, not just 1. How can I edit this to do that and not lose everything that it currently does.

(Here is the table so far and you can see the issue on the Sutton Coldfield row, where the days since should be 7)

123.PNG