How to link checkboxes to cells
Now, this is where the fun begins.
A visual checkmark in a checkbox doesn’t allow for any calculation. It’s pure visuals.
But you can link the checkbox to a cell so it displays a TRUE or FALSE value when it’s checked or unchecked.
It’s basically like making a cell reference.
1. Right-click on the first checkbox and click ‘Format Control’
2. In the ‘Format Control’ dialog box, go to the ‘Control’ tab.
3. Select the ‘Unchecked’ option (radio button). That ensures the checkbox is unchecked by default when you open the spreadsheet containing it.
If you want the checkboxes to be checked by default, then select that option instead🕵️♂️
4. In the ‘Cell link’ box make a reference to the cell you wish to display either TRUE or FALSE depending if the checkbox is checked or unchecked.
Checked = TRUE, unchecked = FALSE.
5. Do the same for all the checkboxes.
It should look like this by now.
If the FALSE (or TRUE) values don’t show, try checking and unchecking the checkboxes a few times.
Now, all you need is a formula that adds up the upsells.
6. Write the formula:
=SUMIF(D2:D5, “TRUE”, B2:B5)
And that’s it!
Your interactive user interface now adds up the upsell prices from the chosen upsells. All selected by checking and unchecking cool-looking checkboxes.
To make this look prettier, change the font color to white on all the linked cells.