Pyramid sum

[Hans K]

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

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

 

[StephenCrump]

Try:

	A	B	C
1	623498
2
3	Result	9
4
5	In detail	Split	Pascal
6		6	1
7		2	5
8		3	10
9		4	10
10		9	5
11		8	1
12
13		139
14	Result	9
Sheet1

Cell Formulas
Range	Formula
B3	B3	=MOD(SUMPRODUCT((0+MID(A1,SEQUENCE(LEN(A1)),1)),COMBIN(LEN(A1)-1,SEQUENCE(LEN(A1),,0))),10)
B6:B11	B6	=0+MID(A1,SEQUENCE(LEN(A1)),1)
C6:C11	C6	=COMBIN(LEN(A1)-1,SEQUENCE(LEN(A1),,0))
B13	B13	=SUMPRODUCT(B6#,C6#)
B14	B14	=MOD(B13,10)
Dynamic array formulas.

The calculation is the SUMPRODUCT of
1. Each digit in the number, and
2. The number of ways each digit will be included in the sum, which is Pascal's triangle - draw each step of the pyramid and you'll see, for example, that there is only one path for the first digit, 6, and 10 paths for the middle digits, 3 and 4.

 

[Hans K]

Thank you very much StephenCrump.