Forum Discussion

jadriano24's avatar
jadriano24
Copper Contributor
Jan 14, 2021

Excel checkbox

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 o...
jadriano24's avatar
jadriano24
Copper Contributor
Jan 18, 2021

adversiThanks for your response. I actually figured out what I needed to do through some trial and error formulas. I used Format Control to link the checkboxes to reference cells (way off to the side of the worksheet) so that when the checkbox is checked, it will return TRUE, and if cleared it will return FALSE. Then I used the SUMIF function to do the calculations when the checkbox is checked.

 

But, I am curious as to know how you would have done it. I've attached a sample file and would love your input.

adversi's avatar
adversi
Iron Contributor
Jan 18, 2021

jadriano24 Your solution looks great! My suggestion follows the same concept, using a binary output that can be used for a SUMIF formula, more focused on a data entry level.

  • jadriano24's avatar
    jadriano24
    Copper Contributor
    Jan 20, 2021

    adversi I'll keep your suggestion in mind for the future. Thanks for reaching out.

     

    Enjoy the rest of your day.

Resources