Thread: Create a drop down that adds up a price
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default Create a drop down that adds up a price
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.
Reply With QuoteReply With Quote