how can I tell SUM that letter "X" = 10 for totalling purposes
 

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?

how can I tell SUM that letter "X" = 10 for totalling purposes
 

I'm a bit confused but
=countif(a:a,"x")*10
or
=COUNTIF(I:I,"x")+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?

how can I tell SUM that letter "X" = 10 for totalling purposes
 

=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?