View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Boku Boku is offline
external usenet poster
 
Posts: 2
Default calculate sum of product randomly and exhaustively

Say I have 5 numbers located in A2, C2, E2, G2, I2.
How to calculate the summation of each 3 random product exhaustively?
That is
A2*C2*E2 +
A2*C2*G2 +
A2*C2*I2 +
..... +
E2*G2*I2
=result.

What if 5 numbers to be N numbers and 3 multiplications to be M times?

Thanks!