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