How do I assign a fixed number value to text?
 

So when the text is selected, there is an underlying value that can be
totaled, for example. Thanks.

How do I assign a fixed number value to text?
 

Example? Please be more specific when you ask a question.

"GooseGirl" wrote:

So when the text is selected, there is an underlying value that can be
totaled, for example. Thanks.

How do I assign a fixed number value to text?
 

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.

"Toppers" wrote:

Example? Please be more specific when you ask a question.

"GooseGirl" wrote:

So when the text is selected, there is an underlying value that can be
totaled, for example. Thanks.

How do I assign a fixed number value to text?
 

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


Replace @mailinator.com with @tiscali.co.uk


"GooseGirl" wrote in message
...
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.

"Toppers" wrote:

Example? Please be more specific when you ask a question.

"GooseGirl" wrote:

So when the text is selected, there is an underlying value that can be
totaled, for example. Thanks.

How do I assign a fixed number value to text?
 

Thanks, Sandy. It worked perfectly!

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"GooseGirl" wrote in message
...
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.

"Toppers" wrote:

Example? Please be more specific when you ask a question.

"GooseGirl" wrote:

So when the text is selected, there is an underlying value that can be
totaled, for example. Thanks.

How do I assign a fixed number value to text?
 

You're welcome. Thanks for the feedback.

--
Regards,

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


Replace @mailinator.com with @tiscali.co.uk


"GooseGirl" wrote in message
...
Thanks, Sandy. It worked perfectly!

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk