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
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