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.

Public Function SumScalarProduct(Scalar As Double, ProductArray  As Range)
  Dim ProdCell As Range
  Dim Total

    For Each ProdCell In ProductArray
      Total = Total + (Scalar.Value * ProdCell.Value)
    Next ProdCell
  
    SumScalarProduct = Total
End Function

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

Sincerely,
Leith Ross

=SUMPRODUCT(A1*B1:B10)

--
Regards,
Tom Ogilvy


"phil2006" <phil2006.2bcrf4_1153581308.0755@excelforum-nospam.com> wrote in
message news:phil2006.2bcrf4_1153581308.0755@excelforum-nospam.com...
>
> 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
>