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

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B
1
2	1024	7
3	123456789	45
Data

Cell Formulas
Range	Formula
B2:B3	B2	=SUM(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)+0)

 

[KRice]

Here is another approach:

MrExcel_20220909.xlsx
	A
1
2	45
3	123456789
Sheet4

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

Edit: I suppose it's more sensible to use the 0+ rather than 1* approach to coerce text to numbers...revised above.

 

[FormR]

Hi, and another twist, if you have a sensible maximum number of digits that could be in the cell (I've used 15 in this example)

Book1
	A	B
1
2	1024	7
3	123456789	45
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=SUM(MID(A2&REPT(0,15),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},1)+0)

 

[JulianvO]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B
1
2	1024	7
3	123456789	45
Data

Cell Formulas
Range	Formula
B2:B3	B2	=SUM(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)+0)

 

[JulianvO]

Greetings Fjuff

Thanks for the speedy reply. I will try your solution.

 

[Fluff]

I would suggest using the formula from post#3 as it's not volatile

 

[JulianvO]

Greetings

Thanks for the speedy reply. i will try your solution and see if it is what I require.

 

[JulianvO]

Greetings

Thanks for the speedy reply. I will try your solution and see if it is what I need.

 

[JulianvO]

Greetings

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

What am I doing wrong?

Remember there is no text, commas, spaces or + signs, just the number.

The reason I need this is as follows:

Example:
Take number 1024. the sum total of this number 7 (1+0+2+4)
Now minus 7 from 1024 and you get 117. This remaining number is always divisible by 9. Answer is 13.
AS 9 is the square root of 3, the number will also be divisible by 3. Answer 39.

The above will apply to any number greater than 9. There will never be a remainder.