How do I assign a fixed number value to text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So when the text is selected, there is an underlying value that can be
totaled, for example. Thanks.
 
I want to create a simple drop-down list, i.e., apples, bananas and cheese.
Apples would have a background (unseen) value of 12, bananas 9 and cheese 4.
After items were selected from the drop-down list, the unseen value could be
totalled at the bottom of the list.
 
One way:

Sum the list with:

=SUMPRODUCT((C3:C23={"Apples","Bananas","Cheese"})*({12,9,4}))

Where the dropdown list is in C3:C23

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thanks, Sandy. It worked perfectly!

Sandy Mann said:
One way:

Sum the list with:

=SUMPRODUCT((C3:C23={"Apples","Bananas","Cheese"})*({12,9,4}))

Where the dropdown list is in C3:C23

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
You're welcome. Thanks for the feedback.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top