I've created an Excel spreadsheet for a customer that has multiple jobsites. Each jobsite has multiple open invoices with the sum of all the invoices at the bottom. I would like to check a checkbox once the invoice is paid and have the amount of that invoice subtracted from the total. How do I go about doing this?
@jadriano24 Instead of a checkbox, you can create a helper column to track what's been paid and use the SUMIF function to control what's being summed. If you can share your workbook, without any sensitive data, we can create a working template