Sum of the digits of a number non-recursively

[Kolterdyx]

Hi, I’m having trouble trying to get this working.
I have a setup like this:

       A       B        C
------------------------------
1 |  1234   |  12   |  1234

I want to sum the digits of A1 (10), then the digits of B1 (3) and then the digits of C1 (10), and them add them together. Where I am stuck is trying to add the digits together, because all of the methods that I’ve found are recursive and for A1 I would get 1 instead of 10. How can I get the sum of the digits of the number in each cell non-recursively?

[robleyd]

One way to get the sum of digits in e.g. A1
=SUMPRODUCT(VALUE(MID(A1;ROW(INDIRECT("z1:z"&LEN(A1)));1)))

Found at [Solved] Calculating digit sum of integers in a column (View topic) • Apache OpenOffice Community Forum

[karolus]

the aggregated Sum of digits from the range A1:C1

=SUMPRODUCT(IFERROR(VALUE(MID(TEXTJOIN("";1;A1:C1);ROW(1:10000);1));0))