How do I assign a fixed number value to text?

's Computer Specifications

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

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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 Removed)
Replace @mailinator.com with @tiscali.co.uk

"GooseGirl" <(E-Mail Removed)> wrote in message
news:08C8EA0E-74FD-4AAF-A714-(E-Mail Removed)...
>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.
>

's Computer Specifications

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
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "GooseGirl" <(E-Mail Removed)> wrote in message
> news:08C8EA0E-74FD-4AAF-A714-(E-Mail Removed)...
> >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.
> >
>
>
>

's Computer Specifications

You're welcome. Thanks for the feedback.

--
Regards,

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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk

"GooseGirl" <(E-Mail Removed)> wrote in message
news:44501C76-6615-42F0-9FF1-(E-Mail Removed)...
> 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
>>
>> (E-Mail Removed)
>> Replace @mailinator.com with @tiscali.co.uk

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert fixed number to text.	john	Microsoft Excel Misc	2	30th Jan 2009 09:22 PM
assign a number value to a text. ie, PL equals .5	=?Utf-8?B?SldEZXNpZ25z?=	Microsoft Excel New Users	3	8th Dec 2005 05:03 PM
How do I assign a text value to a variable number of rows?	=?Utf-8?B?SmRheQ==?=	Microsoft Excel Worksheet Functions	6	20th Jun 2005 01:46 PM
assign number value to text	2fast	Microsoft Excel Misc	1	18th May 2004 02:30 AM
Assign number value to a field with text in it?	sleland	Microsoft Excel Misc	3	7th Jan 2004 04:11 PM