ramananhrm
Board Regular
- Joined
- Apr 19, 2011
- Messages
- 156
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
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