Looks like no one’s replied in a while. To start the conversation again, simply ask a new 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 Mar 11, 2018 9:14 AM

Reply
Question marked as Best reply

Posted on Mar 11, 2018 11:02 AM

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

2 replies

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.