Thread: how can I tell SUM that letter "X" = 10 for totalling purposes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trequoit Trequoit is offline
external usenet poster
  
Posts: 1
Default 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?
Reply With QuoteReply With Quote