Apple Event: May 7th at 7 am PT
Question marked as
Best reply
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
There are no replies.
Minus a value from column b if a checkbox is checked in column c from a total