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

Question

Klyncher1982 Author

Level 1

4 points

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 Mar 11, 2018 9:14 AM

Reply

Answer 1

turingtest2

Level 10

278,269 points

Mar 11, 2018 11:02 AM in response to Klyncher1982

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

Reply

Answer 2

turingtest2

Level 10

278,269 points

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

Of course I meant:

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

😊

tt2

Reply