Dynamically calculating values in a row

Hi All,

I am new here. I have a problem, for which i am no headway at the moment, i need help.

I have a row with values that i want to calculate the amount for when a threshold is met e.g. A1 + B1 = 3 (lets say the threshold is 3), then starts calculating from C1, so if C1 + D1 + E1 = 3, then start calculating from F1 and so forth. It would benefit me if a could return a 1 or 0, otherwise if i can return the value calculated that would be fine as well.

Please if anyone can help.

Regards
Sam