| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get text to equal a number so I can sum a column?
I am creating an Excel document where I place the letter X in a column and
want those X's to be added up and totaled at the bottom row. For example: B2 - X B3 - X B4 - X B5 - 3 As you can see, B5 has the result of 3 X's being input on B2:B4. So, how do I get the letter X to be recognized as a numerical 1 to be added? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Add total number of rows (text) in a column | Excel Worksheet Functions | |||
| The last column in my word document contains both text and number | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Threaded Mode
