I want to be able to subtract a value of a total using checkboxes. Let's say I have values in Column A (10,20,56) and A4 is the total, on column B I have checkboxes for each row. Now, when I click on the checkbox next to the value 10, I will like to subtract that value from the total on A4(86), so the result will get 76. Subsequently, if I click on the checkbox next to 20, then the value of the total (A4) will change to 56.

Google Sheet Picture

  • Welcome to Web Applications Stack Exchange. Your problem description does not match the screenshot. The answer below follows the description and not the screenshot. Please edit your question and insert a table of sample data. Also consider sharing a publicly editable sample spreadsheet. There is a blank sheet maker that lets you share safely Feb 19 at 16:40

1 Answer 1


Use filter() to get the rows where the checkbox is not ticked, and sum those rows, like this:

=sum(filter(A1:A4, not(B1:B4)))

See filter().

  • Thank you, this definately has helped.
    – Jose Dlr
    Feb 19 at 17:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.