What I'm trying to do here is review weights, week by week. If a player loses weight for the third week (across any date range) then consider that a "Hat Trick". Hat Tricks can only be scored on the week they are achieved.

So, as you'll see from the example, the weights are added in weekly, and the formula I'm using shows correctly whether the range of cells showing as "losing weight" is divisible by 3 (i.e. denoting a hat trick), however when the next week is added, if the player has NOT lost weight, the formula still thinks that a hat trick is due. I know I need to include the date somehow but I'm stumped.

Can you help?

sample_ceepeebee.xlsx