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
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
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
Of course I meant:
=B7−SUMIF(C2:C6,TRUE,B2:B6)
😊
tt2
Minus a value from column b if a checkbox is checked in column c from a total