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