Would like to keep updating single cell when conditions are met

Copper Contributor

E.g.  cell A19 has a value of 100.  cell A4 has a value of 10 with an adjacent B4 cell that will either have or not have a check mark.  I would like cell A19 to update to 90, IF B4 has a check mark. i would like this formula to be true to a range of values in the same columns continuously updating A19. So, if B5 has a checkmark, then A19 needs to subtracts value of A5.  etc etc etc.

 

I hope this makes sense. Thank you

1 Reply

@AIKKID 

Enter the base value 100 in another cell, e.g. A20.

In A19:

=A20-SUMIF(B4:B18,"<>",A4:A18)