| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Product Code and Product Description setup | Excel Worksheet Functions | |||
| I need a product key for my Trail product, 2007 Microsoft Office s | Setting up and Configuration of Excel | |||
| Functin to calculate arguments for a product? (12= 12*1, 4*3, 6*2. | Excel Worksheet Functions | |||
| How do I calculate cost of raw materials to final product? | Excel Discussion (Misc queries) | |||
| Randomly choosing | Excel Worksheet Functions | |||
Threaded Mode
