Sum towards single digit

[ramananhrm]

Hi,

I have a query on the sum within the cell towards single digit.

The cell A1 has a value eg '756456455'.

I have used with three steps:
1. =SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) gives 47
2. =SUMPRODUCT(--MID(B1,ROW(INDIRECT("1:"&LEN(B1))),1)) gives 11
3. =SUMPRODUCT(--MID(C1,ROW(INDIRECT("1:"&LEN(C1))),1)) gives 2

How do we cut down to a single step which gives a final answer for '756456455' as 2

Please help me out

 

[pgc01]

Hi Ramanan

For an interger bigger than 0, try:

=MOD(A1-1,9)+1

 

[ramananhrm]

Hi PGC01,

Thank you so much.

100% accurate.

 

[pgc01]

You're welcome. Thanks for the feedback.