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

Question:

# Question:Q: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)

Posted on

Question marked as Solved

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

Question marked as Solved

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

Mar 11, 2018 11:02 AM

Mar 11, 2018 11:08 AM in response to turingtest2 In response to turingtest2

Of course I meant:

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

😊

tt2

Mar 11, 2018 11:08 AM

User profile for user: Klyncher1982

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