Excel: calculate the amount - the numbers from a cell (58391) in another cell (5+8+3+9+1)

Question

I have an excel cell that contains the number 58391. Is there a formula that can count (calculate the amount) the numbers (5+8+3+9+1) in another cell?

Answer 1

Use SUMPRODUCT:

=SUMPRODUCT(--MID(A1,ROW($ZZ$1:INDEX($ZZ:$ZZ,LEN(A1))),1))

The Mid returns an array of the numbers, by iterating the start position from the array of numbers that the ROW returns.