You can use the following macro in the worksheet module for Sheet1 (right-click on sheet tab and select View Code, then paste this code into the vb editor window). Anytime your sheet calculates it should reset column C to 0 if column H changes to TRUE in that row.
I also changed two of your formulas a little.
In cell G2 use this instead of the nested IF's. Fill down col G as far as needed:
In H2 you don't need the IF statement. The AND function will either result in TRUE or FALSE automatically. (Plus, your T/F results were strings, not boolean values.) Fill down col H as far as needed.
Bookmarks