How to create a form with multiple options that sum prices etc.??

[Hamish]

Hi all,

I need to add form into my spreadsheet that allows the user to click on the list, then select multiple check boxes or options. Each option needs to display an item description and a price. If one item is selected then only that dollar amount and description is added to is the total. If multiple options are selected then a list of items are displayed in the sheet and their individual prices shown and summed at the bottom.

 

[Luke M]

Welcome to the forum!

I'd take a look at Debra's code and sample workbooks here:
http://blog.contextures.com/archives/2012/05/22/add-products-to-excel-order-form/
and here:
http://www.contextures.com/xlOrderForm01.html

For a simple standpoint, if you have a giant list somewhere, and you place marks (through checkboxes linked to cells, or directly), you can generate a list of all items via this formula:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/
and then use VLOOKUP and SUM to bring in the dollar amounts and add them up.

 

[Hamish]

Thanks! I'll give it a go and let you know how I progress.