Sum all digits in single cell

[Jan Kalop]

29=11 I can get by using in B1 formula =SUM(VALUE(MID(A1,ROW($I$1:OFFSET($I$1,LEN(A1)-1,0)),1)))
and then again using in C1 =SUM(VALUE(MID(B1,ROW($I$1:OFFSET($I$1,LEN(B1)-1,0)),1)))
I get final 2
How I can get that "2" in one single formula,please.

 

[XOR LX]

Hi,

=1+MOD(A1-1,9)

Regards

 

[Jan Kalop]

Fantastic, thank you very much.

 

[XOR LX]

You're welcome!

Cheers

 

[deciog]

Jan Kalop


Your formula works to add the numbers but you have to press CTRL+SHIFT+ENTER


{=SUM(VALUE(MID(A1,ROW($I$1:OFFSET($I$1,LEN(A1)-1,0)),1)))}


So you will have the result 11 to the sum of the numbers


Decio