Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Minus a value from column b if a checkbox is checked in column c from a total

Hi


i want to set up a sheet in numbers that does the following. If I check column C3 I want the value of B3 to be taken away from the total value in b7 to give a total value in b8 of 2018 (ie 2020 - 2)


User uploaded file

Posted on

Reply
Question marked as Solved
Answer:
Answer:

The first error is the leading B8, not required. The second term in the SUMIF should just be true.


This works:


=B8−SUMIF(C2:C6,TRUE,B2:B6)


tt2

Posted on

Page content loaded

User profile for user: Klyncher1982

Question: Minus a value from column b if a checkbox is checked in column c from a total