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!
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!