| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
spit & sum comma delimted value
Hi
Need to split cell values and sum. Cell A1: 0,20,300,20,300 Cell A2: 280,34,200,129,0 Result for A1 = 640 Result for A2 = 643 Note that the length of cell and values are not consistent. Any help much appreciate. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CANNOT Import comma delimted, quote qualifed text file into Excel. | Excel Discussion (Misc queries) | |||
| how do I open a comma delimted file so that all the fields are se | Excel Discussion (Misc queries) | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Threaded Mode
