I have the following function give me results in a cell:
An example of what this will give is "=Factors(6)" provides "1,2,3,6".
This is all in one cell and what I want to do is have these add up in the next cell, so say that result was in cell A1 and then i went the sum of these factors to be in A2, how would I do it? I've already tried "=SUM(A1)" and it gave 0 because "1,2,3,6" is not considered a list of numbers but one large non-number. Even with spaces after the commas it doesn't work. IT would be great if someone could provide a solution for this. Thanks!
-Shoubakka
Bookmarks