Try this

=SUMPRODUCT(CODE(UPPER(A1:A4))-64)

Mike

"George" wrote:

Excel 2007;
I am looking for help with a formula that would let me add the values of
letters in a cell. ie. cells A1 - A4 have the letters A or B or C or D, the
letter A = 1 point, the letter B = 2 points, the letter C = 3 points, and the
letter D = 4 points. In cell A7 I need a total of all the points - in this
case the total would be 10