=COUNTIF(I:I,"x")*10+SUM(I:I)

--
Don Guillett
SalesAid Software

"Trequoit" wrote in message
...
I have a score chart which requires certain scores to be shown as letters,
eg
X, but obviously the SUM function does not count this. Is there an easy
way
in Excel 2002 to tell the program that where it sees the text "X" it
should
count this as a value of 10 eg 5+5+X+5 = 25?