Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combinations - multiplied sum of doubles, triples, quadruples.....
Hi. I need to find the multiplied sum of double, triple, quadruple...
combinations in a row, both separately and combined. e.g. 1 2 3 4 2 5 4 6 doubles (2*5)+(2*4)+(2*6)+(5*4)+(5*6)+(4*6) triples (2*5*4)+(2*5*6)+(2*4*6)+(5*4*6) ....and so on... Is there a way to do this in excel? many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing doubles | Excel Worksheet Functions | |||
Sorting doubles | Excel Discussion (Misc queries) | |||
Complex Formula to Find Doubles | Excel Worksheet Functions | |||
Cell height doubles after paste | Excel Discussion (Misc queries) | |||
How do I set up a Doubles Tennis roster for 12 players? | New Users to Excel |