Need formula for Sum of single Cell
It needs to be entered as an array formula.
After you paste my formula into cell B2, press F2 to edit the cell.
Then press Ctrl-Shift-Enter.
Then you should see the correct result.
But if I were you, I would use the formula that mows posted instead of
mine. It is a much simpler solution, and does not need to be entered
as an array.
Tim C
Quote:
>Thank you Tim
>but it not work for me
>I insert your formula into my worksheet at col B1 while in the col A1 is 18
>the result I got is 1 at B1
>I'd B1 will be 9
>Would you look at it for me again Tim
>I'm very pool excel formula
>Thanks again
>> One way:
>> =SUM(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))
>> Enter as an array (Ctrl-Shift-Enter).
>> Tim C
>> >Hi all
>> >I try to get the sum of the single cell that contents 2, or 3 digits
>numbers
>> >such as
>> >in the A1 contents 13 at B1 I need sum it = 4
>> >in the A2 contents 25 at B1 I need sum it = 7
>> >How do I do it
>> >any suggestion very helpful
>> >thanks
>> >ex:
>> > A B
>> > 13 4
>> > 25 7
>> >and so on ...(I have 100 rows)
>> >B is a sum of A