Which is what it does!

--
__________________________________
HTH

Bob

"George" wrote in message
...
Thanks Bob, but any of these letters can change cells, ie. I may want to
enter the letter A (worth 5 points) in a different cell, not always the
first
cell. So where ever A is entered 5 points, and where ever G is entered 2
points.

"Bob Phillips" wrote:

=SUMPRODUCT(LOOKUP(A1:A4,{"A","B","C","D","E","F", "G","H"},{5,4,3,2,2,2,2,2}))

--
__________________________________
HTH

Bob

"George" wrote in message
...
Sorry Mike, bad example, in reality the letter A = 5 points, the letter
B
= 4
points, the letter C = 3 points, the letters D - H would equal 2 points
each
and the letters I - M would equal 1 point each.

"Mike H" wrote:

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