Sum Total Value of a Single Cell

[JulianvO]

Greetings

Cell - A1 To contain formula

Cell - A2 To Display result of value entered into Cell A3

Cell - A3 Cell in which a numeric value is entered.

Formula must be-able to the sum total of the value entered into A3 and display the result in A2.

Example of Value entered into A3 1024 (No commas. spaces or plus signs. Just the number)

Sum total to be displayed in A2 must be 7 (1+0+2+4 = 7)

Example of Value entered into A3 123456789 (No commas. spaces or plus signs. Just the number)

Sum total to be displayed in A2 must be 45 (1+2+3+4+5+6+7+8+9=45)

Thanks

 

[KRice]

If you place the formula in A1, the sum of the digits should appear in cell A1. Could you copy the formula from cell A1 and post it here, please?

 

[Fluff]

@JulianvO please stop making posts that contain nothing but a quote. Thanks
If you want to refer to a specific person you can mention them, as I have at the start of this post.

 

[Fluff]

I have placed the formula into A1. I enter the following value 1024, into A3 and nothing happens.

Did you change the formula to look at A3 rather than A2?

 

[JulianvO]

Did you change the formula to look at A3 rather than A2?

 

[JulianvO]

Greetings

I entered the number in A2, and when nothing happened, I entered the number into A3, after deleting the number in A2.

 

[Fluff]

@JulianvO please STOP making posts with nothing but a quote, I have once again deleted it.

 

[JulianvO]

As requested. This is the formula as per your post.

Thanks

 

[Fluff]

There is no formula in your post.

 

[JulianvO]

Greetings Fluff

=SUM(0+MID(A3,ROW($A$1:INDEX($A:$A,LEN(A3))),1))

I placed the above formula into A1. Entered a number into A2 and pressed enter- Nothing but the number I entered. Deleted the number in A2.

I entered the number into A3 and pressed enter- Nothing but the number I entered in A3

Obviously, I am missing something

Thanks

 

[KRice]

I am not understanding the issue:

MrExcel_20220909.xlsx
	A
1	36
2
3	12345678
Sheet4 (2)

Cell Formulas
Range	Formula
A1	A1	=SUM(0+MID(A3,ROW($A$1:INDEX($A:$A,LEN(A3))),1))

...seems to work fine. Could you post a snapshot of your worksheet using the XL2BB add-in?