I'm trying to make a simple calculator in Google Sheets with checkboxes for certain values. For simplicity I'll refer to these Checkboxes as A and B. What I would like to have is the user selects A, B, either, or both and have that output value. However, I want the user to be able to unselect these boxes, but the total from the first value is unaffected.
Right now I have A=5 and B=10. I can check both, and get 15 in a separate cell. I can then subtract that cell from the total. However, when I uncheck the boxes, the values, including the total reset. Is there a function I can use that will total only when commanded, and the result is independent of if the boxes are checked or not?