| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I add/sum the numbers in one cell...((More Info Below))
Hello. What I'm doing exactly is Let's Say A1 I have this:
1,5,8,9,10,12 And Now in A2 I want to put the sum of these numbers... So I want to add the numbers even though they consist of commas. Is this possible!? Hope you all can help me. Thank you for your replies... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How Do I add/sum the numbers in one cell...((More Info Below))
This is not the ideal solution and is undoubtably very inefficient but for
the one example you listed it works. One of the more savvy formula gurus will probalby come up with something far better but this might at least give you a place to start. =LEFT(A1,1)+MID(A1,3,1)+MID(A1,5,1)+MID(A1,7,1)+MI D(A1,9,2)+RIGHT(A1,2) "Gregorio" wrote: Hello. What I'm doing exactly is Let's Say A1 I have this: 1,5,8,9,10,12 And Now in A2 I want to put the sum of these numbers... So I want to add the numbers even though they consist of commas. Is this possible!? Hope you all can help me. Thank you for your replies... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
