actually, the way i understand the formula is each term is multiplied by the other only once...x1*x2 is same as x2*x1 so in this example, if there are 5 weigths, there is only 10 multiplications...that is what i have in the sheet...where i have a problem is writing the macro that spits out the end result/putting the loop together in vba.