MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Checkbox sum


Posted by Scott on August 03, 2001 8:05 AM

I want to use checkboxes for a list of products (apples,oranges,bananas,etc.).
Each product has a price for it.
I want to set up my sheet so that if apples is checked, it returns the price of apples to the total sum cell....How can I do this?

Product.....Price........
Apples......$1.00
Bananas.....$1.50
Oranges.....$1.75

Total Sum...

Would appreciate any help with this.
Scott


Posted by lenze on August 03, 2001 8:57 AM

Scott: I believe this will be easier if you use Option buttons instead of check boxes. After you have inserted the option buttons, choose format and assign a cell reference to the group. Now you can write a formula (VLOOKUP or CHOOSE, etc.) to return the correct price based on the value of the reference cell, which depends on the option button chosen.

Posted by Scott on August 03, 2001 9:02 AM

I don't think option buttons would work, because I want to be able to check more than one item (up to 100) and then get the grand total of the checkboxes which are checked.

Such as, if apples and oranges are checked, the grand total would be $2.75...

Posted by lenze on August 03, 2001 9:51 AM

OK: You can do the same thing with check boxes by creating a table with the referenced cells for an item next to the price. The Reference cell will be either TRUE or FALSE. You can then use SUMIF to add prices where Reference cell values are TRUE

Posted by Scott on August 03, 2001 5:36 PM


Okay, I got that to work....Thank you so much...
Now, how do I put my table into FrontPage, so that visitors to my site can use my table.....I've tried Copy/Paste, but I lose my formula functuality.....Any ideas?

Posted by lenze on August 06, 2001 7:12 AM

Scott: I'm not familiar enough with Front Page to help. Maybe you can repost on that issue.