I would like to have a letter represent a number and to be able to calculate
to get a sum.

Example X= ".5" = 0.5

Insertnamesdefine

put

=5

in the refers to and

X

in the names box

--


Regards,


Peo Sjoblom

"JRD920" wrote in message
...
I would like to have a letter represent a number and to be able to
calculate
to get a sum.

Example X= ".5" = 0.5

What will you do with the number?

You can't SUM just .5

Maybe count all "x" and divide by 2?

=COUNTIF(Range,"x")/2

Or something else...........?

=LOOKUP(B1,{"A","B","X"},{1.5,1,0.5}) + A1


Gord Dibben MS Excel MVP


On Wed, 6 Aug 2008 12:59:02 -0700, JRD920
wrote:

I would like to have a letter represent a number and to be able to calculate
to get a sum.

Example X= ".5" = 0.5

If you have a larger list of letter-value combos, you might just want to
create a lookup table and then use a vlookup for the translation.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"JRD920" wrote:

I would like to have a letter represent a number and to be able to calculate
to get a sum.

Example X= ".5" = 0.5