Mike, thanks again, I pluged in the formula and it works. Next problem, some
of the cells will be blank, when these cells are left blank, it does not
total.

"Mike H" wrote:

OOPS

=SUMPRODUCT(LOOKUP(A1:A7,{"A","B","C","D","H","I", "M"},{5,4,3,2,2,1,1}))

Mike

"Mike H" wrote:

Maybe

=SUMPRODUCT(LOOKUP({"A","B","C","D","H","I","M"},A 1:A7,{5,4,3,2,2,1,1}))
Mike

"George" wrote:

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