Excel checkbox

%3CLINGO-SUB%20id%3D%22lingo-sub-2061969%22%20slang%3D%22en-US%22%3EExcel%20checkbox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2061969%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20created%20an%20Excel%20spreadsheet%20for%20a%20customer%20that%20has%20multiple%20jobsites.%20Each%20jobsite%20has%20multiple%20open%20invoices%20with%20the%20sum%20of%20all%20the%20invoices%20at%20the%20bottom.%20I%20would%20like%20to%20check%20a%20checkbox%20once%20the%20invoice%20is%20paid%20and%20have%20the%20amount%20of%20that%20invoice%20subtracted%20from%20the%20total.%20How%20do%20I%20go%20about%20doing%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2062744%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20checkbox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2062744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F926329%22%20target%3D%22_blank%22%3E%40jadriano24%3C%2FA%3E%26nbsp%3BInstead%20of%20a%20checkbox%2C%20you%20can%20create%20a%20helper%20column%20to%20track%20what's%20been%20paid%20and%20use%20the%20IF%20function%20to%20control%20what's%20being%20summed.%20If%20you%20can%20share%20your%20workbook%2C%20without%20any%20sensitive%20data%2C%20we%20can%20create%20a%20working%20template%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

1 Reply

@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