Hi,

I'm trying to make an excel workbook that calculates various values and
statistics for games of scrabble. One of the things I want the sheet to
do is to automatically update the sum total for the points for a given
set of letters. For instance, if I type into cell A1 the letters "BAT"
I want cell B1 to output "5", by knowing that the letters have the
following values and summing them: B=3, A=1, T=1. I've tried using the
COUNTIF() function:

=SUM((COUNTIF(A1,"*"&{"A","B","C","D","E","F","G", "H","I",
"J","K","L","M","N","O","P","Q","R","S","T",
"U","V","W","X","Y","Z"}&"*")0)*{1,3,3,2,1,
4,2,4,1,8,5,1,3,1,1,3,10,1,1,1,1,4,4,8,4,10})

however the function only seems to count unique letter values, and
cannot handle words with two or more instances of one letter. For
example, the word "letter" is given a value of "4", but should be "6",
however only one "t" and one "e" are counted. Any suggestions?

Thanks!