Probabilities

I have a number of probabilities and need to multiply them by numerous other probabilities. Is there any way of multiplying cell A1 by cells B1:b20 and summing the totals?

Thanks

Hello Phil2006,

Here is macro that should do what you need.

Please Login or Register  to view this content.

Example of using the Macro:
Result = SumScalarProduct(Range("A1").Value, Range("B1:B20"))

Sincerely,
Leith Ross

=SUMPRODUCT(A1*B1:B10)

--
Regards,
Tom Ogilvy


"phil2006" <[email protected]> wrote in
message news:[email protected]...
>
> I have a number of probabilities and need to multiply them by numerous
> other probabilities. Is there any way of multiplying cell A1 by cells
> B1:b20 and summing the totals?
>
> Thanks
>
>
> --
> phil2006
> ------------------------------------------------------------------------
> phil2006's Profile:
> http://www.excelforum.com/member.php...o&userid=35092
> View this thread: http://www.excelforum.com/showthread...hreadid=563982
>