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

[Adam]

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

 

[Jim May]

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

 

[Jon Peltier]

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