Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! I need a formula to add numbers separated by commas within
Hello. I have a spreas sheeit in which each cell has various number
seperated with commas. For e.g. 100, 200, 300, 400 are in one cell. I have an entire worksheet in which each cell has multiple numbers and I need for each cell to be summed up individually. So if I have 100, 200, 300 in a cell, I need it to add up and read 600. I can go into each cell individually and enter the =sum but that would take me forever with an entire spread sheet. Is there a way I can highlight the spreadsheet and enter a formula that will automatically add up each individual cell so I don't have to enter =sum in each individual cell? I hope I'm being clear. Please help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Numbers with Commas from Outside Source | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
how to count occurence of numbers separated by , in a single cell | Excel Worksheet Functions | |||
many numbers in one cell separated by hyphen. | Excel Discussion (Misc queries) |