How to format checkboxes to subtract values in other cells from a total for budget sheet

[mshular]

Hi! I was hoping to find help with formatting an excel spreadsheet for a budget worksheet for loan applicants. I need the check boxes under the "RF" column in the Debts section to subtract the payment (and if possible the balance also) from the totals for post-loan due others (Cells I65/J65 & S65/T65) for consolidating debts for applicants so I can get an accurate view of the budget I'm working with.

For example, if we're paying off a credit card for applicant 1, when the checkbox is marked for that debt, then the total in J65 should be 40 less than the total in J64, and if also possible, the total in I65 should be 500 less than the total in I64 to reflect the change in the applicant's outflows for the monthly budget after the loan.
I'm sure it can be done, but I don't know how to write the formula in excel to make it work.

TIA for taking the time to look into this, and thank you to anyone who is able to come up with a solution.

[ORoos]

Hi there,

If I understant you correct, you want the sum of the amounts which are NOT ticked.

In cell 'J64' try: =SUMIFS(J37:J62,$V$37:$V$62,FALSE)

In cell 'I64' try: =SUMIFS(I37:I62,$V$37:$V$62,FALSE)

[Croweater]

or in I64 (and drag across to I65)

=I$64-SUMPRODUCT(($V$37:$V$62=TRUE)*I$37:I$62)