Summing equations

[Lenboy]

I want to form a running sum of lognormal functions illustrated in the attached spreadsheet image.
Cell C4=$B$3*LOGNORM.DIST(C2-$B2,mu,sigma,FALSE)

D4=$B$3*LOGNORM.DIST(D2-$B2,mu,sigma,FALSE)+$C$3*LOGNORM.DIST(D2-$C2,mu,sigma,FALSE)

E4=$B$3*LOGNORM.DIST(E2-$B2,mu,sigma,FALSE)+$C$3*LOGNORM.DIST(E2-$C2,mu,sigma,FALSE)+$D$3*LOGNORM.DIST(E2-$D2,mu,sigma,FALSE)

and so on. Is there a neater way of carrying out this operation in cells F4, G4 etc without having a enter an increasingly longer expression?

Thanks

 

[StephenCrump]

	A	B	C	D	E	F	G	H	I	J
1
2	x	0	1	2	3	4	5	6	7	8
3	Coefficient	4	3	9	2	7	8	5	6	3
4	f(x)	0.00	0.004	0.044	0.142	0.331	0.581	0.872	1.212	1.573
5
6	mu	2.5
7	sigma	0.7
Sheet1

Cell Formulas
Range	Formula
C4:J4	C4	=SUM($B3:B3*LOGNORM.DIST(C2-$B2:B2,mu,sigma,))

Named Ranges
Name	Refers To	Cells
mu	=Sheet1!$B$6	C4:J4
sigma	=Sheet1!$B$7	C4:J4

I'm using Excel365. It should work in older versions if you array-enter the formula.

 

[Lenboy]

Thanks Stephen - an elegant and perfect solution to my problem. I’m using Excel 2019 and just array-entered the formula.
Brian