Counting one cell if another cell is true

[beatledave]

I'm updating my home budget on excel and want to count certain things at different times. For example, column C has all of the amounts of the bills to be paid that month and a total at the bottom, whereas column D has a check box that I tick when each one is paid. Can I link the two so that if I click the check box in D it either adds or subtracts from a total amount? This would be great so I can keep a monthly account of total spending but still manage it day by day.

 

[Iktishaf]

A simple solution is as follows.
1. Use Form Control Check Boxes, not ActiveX ones.
2. For each check box, right-click, select Format Control, then the Control tab, and then in cell link specify a cell in another column, say column I, but in the same row as the check box.
3. Finally, change your column sum to =SUMIF(I3:I20,FALSE,C3:G20) using the appropriate ranges in the sum

 

[beatledave]

You know, it is simple!! Thank you