Create a drop down that adds up a price

D

Dimmchip

I'm trying to create a sheet where I have a series of drop down lists where
each item on this drop down when selected gives me a grand total. For
example, If I have the options:
Apples (.50)
Bananas (.75)
Cherries (1.00)

If I choose apples and cherries in two seperate drop downs, I want to show
my grand total as 1.50.
I know how to create drop downs and validate the data, but I don't know how
to have it reference a price and show a grand running total.
Any insight is appreciated!
 
S

Spiky

Put your options in a little list somewhere. Then use VLOOKUP in the
cells next to your dropdowns to find the prices. And a SUM to add them
up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down lists in seperate columns 5
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Showing information according to a selection in a drop down box 2
dependent drop down list 1
functions 1
Multiple Dependent Drop Downs 0
Drop Down Lists 2
Drop down fill box does not appear when cell clicked. 1

Top