Is it possible to automatically reset the final score to zero if a condition is met??

Hello everyone,

Is it possible if I want to automatically reset the final score (K26 is the sum from the numbers above) to 0 if there's a fatality case (J17=1)? I'm thinking about using IFERROR but I don't think that will work. Thank you in advance
K26.png

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Try

=IF(SUM(J4:J12),0,SUM(K4:K12))

However, as pointed out by Ford in post #3, this remain zero as long as there is a "1" in column J

Maybe something like thos?

=IF(cell-showing-fatal>0,0,sum(range))

However, that will remain 0 for as long as there is a Fatal value

K18:K24 are not shown in your file but iif you mean resetting K4:K12 you will need VBA.

Would you please elaborate more about K18:K24 are not shown in my file? I'm sure the hidden option is off.
I want K18:K24 to automatically scored 0 if J17=1 (or if there's a fatality case). I tried to use IFS formula but I'm not sure if it's right.

There is no data in K18:K24: your data starts in row 1 not row 14 as your picture!

possible solution

=IF(SUM($J$4:J14),0,IF(J4=G4,H4,(-100*J4)))