SUMPRODUCT query

[Lenboy]

I wouldlike to form the sumproduct of an array B1 to B5 with a Gaussian probabilityfunction where the x-values are in cells A1 to A5. I tried the followingexpression


=SUMPRODUCT(B1:B5,NORMDIST(A1,mean,sd,FALSE)):NORMDIST(A5,mean,sd,FALSE))

However,this is invalid and I would be grateful if anyone knows the correct expressionthat would perform this operation, please.

 

[joeu2004]

Syntactically, you might write:

=SUMPRODUCT(B1:B5,NORMDIST(A1:A5,mean,sd,FALSE))

But I suspect that is not correct mathematically. Without a concrete example, it is hard to say what you expect.

 

[Lenboy]

Syntactically, you might write:

=SUMPRODUCT(B1:B5,NORMDIST(A1:A5,mean,sd,FALSE))

But I suspect that is not correct mathematically. Without a concrete example, it is hard to say what you expect.

Thanks - this gives the answer I was expecting