total value of letters from words in cells

[teacher2013]

Hello,

Using 1-26 with the corresponding letter of the alphabet I would like to be able to total the sum of letters from lists of words.

so using 1-26 with A to Z
a = 1
b = 2
c = 3
d = 4
.....



Example:

the word cat = 3+1+20 = 24
dog = 4+15+7 = 26



would appreciate any assistance.

best regards,
Rob

 

[Firefly2012]

Hi Rob

Here's one possibility:

Excel 2007
	D	E
12	cat	24
13	dog	26
Sheet2

Cell Formulas
Range	Formula
E12	=SUMPRODUCT(CODE(MID(UPPER(D12),ROW(INDIRECT("1:"&LEN(D12))),1))-64)

 

[teacher2013]

Thank you. I will give that a try.