View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gotthejazz gotthejazz is offline
external usenet poster
 
Posts: 1
Default 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