choose car, add options, show running total

L

LSilvey

I need to set up an interactive spreadsheet, where users can choose a certain
car, add options, and have a total at the end what that would cost, but only
the options that are chosen are totalled. What formula can I use for that?
 
P

pdberger

I'd suggest you create a section (perhaps a different worksheet) that has the
lists of cars and their costs, and options and their costs. Then set column
a to choose the car (using data validation), and use VLOOKUP to look up the
price. Set another column to choose options (again using data validation)
and again VLOOKUP to look up the respective prices. Then your totals
someplace attractive.

HTH
 
Top