Is it possible to enter a serie of numbers - comma separated - in one cell and then use this "string" as an array in another formula?
For example:
In cell A1 I enter 1,0,0,1,1,1,0
In cell B1 I enter =sum(A1) and the result should have been 4.
I know this doesn't work, but the question is is...