Any chance that StepenCrump or someone else would explain the formula:
=MOD(SUMPRODUCT((0+MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),COMBIN(LEN(A1)-1,ROW(INDIRECT("1:"&LEN(A1)))-1)),10)
(or a better one as I have Excel 365)
See below thread
=MOD(SUMPRODUCT((0+MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),COMBIN(LEN(A1)-1,ROW(INDIRECT("1:"&LEN(A1)))-1)),10)
(or a better one as I have Excel 365)
See below thread
Pyramid sum of six digit in single cell
Respected members, I have six digit number in column A and need pyramid result corresponding cell. For example below - In A1 if record is 123123 then pyramid calculation result 4 need to be shown in B2 123123 4 468477 6 245112 9 Pyramid calculation below 123123 35435 8978...
www.mrexcel.com