Setting letter values in a range of cells to numerics in teh range Sum total

Hi Martin,
The second set of code did accomplish what I am trying to do. Thanks for the fresh approach. Works perfectly.