| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #2: VBA to Pick Range and letter | Excel Discussion (Misc queries) | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| Sort by number not by letter (C1, A2, B3, D4) | Excel Discussion (Misc queries) | |||
| linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
Linear Mode
