| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
choose car, add options, show running total
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
choose car, add options, show running total
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 "LSilvey" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do a set a parameter in cell - choose A or B options? | Excel Worksheet Functions | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| how do i choose multiple options in a drop down menu in excel? | Excel Discussion (Misc queries) | |||
| why the date convert to number when i choose formulas from options | Excel Discussion (Misc queries) | |||
Linear Mode
