HOW CAN A LETTER IE A ,B OR C REPRESENT A NUMBER IE 0.5 OR 2 ETC..
 

I wanted know how can I make a letter ie A or B represent a number, in this
case I wanted all characters represent 0.5. This is to add them all up. At
the end I wanted to collectively sum up how many As, Bs etc.. in numbers:

Mon Tues Wed A=1 B=0.5 etc...
J G A
B H C
N S A
---------------------------
1.5 1.5 1.5

HOW CAN A LETTER IE A ,B OR C REPRESENT A NUMBER IE 0.5 OR 2 ETC..
 

With F1:F7 = A,B,C,G,H,J,N.
Then in Cell G1 enter
=COUNTIF($A$1:$C$3,F1)*0.5 and copy down


"Adam" wrote:

I wanted know how can I make a letter ie A or B represent a number, in this
case I wanted all characters represent 0.5. This is to add them all up. At
the end I wanted to collectively sum up how many As, Bs etc.. in numbers:

Mon Tues Wed A=1 B=0.5 etc...
J G A
B H C
N S A
---------------------------
1.5 1.5 1.5

HOW CAN A LETTER IE A ,B OR C REPRESENT A NUMBER IE 0.5 OR 2 ETC..
 

Make a lookup table that lists letters and numbers in two columns, do
lookups in a parallel range, and do your math on the looked up table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Adam" wrote in message
...
I wanted know how can I make a letter ie A or B represent a number, in this
case I wanted all characters represent 0.5. This is to add them all up.
At
the end I wanted to collectively sum up how many A's, Bs etc.. in numbers:

Mon Tues Wed A=1 B=0.5 etc...
J G A
B H C
N S A
---------------------------
1.5 1.5 1.5