Forum Discussion
Checkboxes and assigning sum totals
Sorry in advance but I'm new to this.
I was asked by my Chief to help with this spreadsheet, basically what we have is a spreadsheet with about 50 checkboxes with options. Each option relates to a price, which I need to add yet. Currently we do it by hand, that is go back through the spreadsheet after it is printed and manually add up the cost based on what is checked. We'd like to link the checkboxes to totals and then have the checked checkboxes total up on the bottom. Is there any way to do this? Thanks!
Is there any way to do this?
Yes.
But what, exactly, is the "this" in this case? That needs to be defined or described or shown a bit more precisely. But be assured, there will be a way once it's defined clearly.
Is it possible for you to post a copy of the file (or a mockup of it, with enough rows to illustrate fully) on OneDrive or GoogleDrive, and then paste a link here that grants edit access to that file? That would be a good way for me (or others here at this site) to see directly what is no doubt hard to describe fully with words.
