In this sheet, I have already set up column A to autofill each unique name from a list. For each of these names I set up an array to pick values from a data set based on the 2 possible names, "L09 Cracks" and "L10 Cracks" in column b and the headers in C through K. I need to weight average each column C through K for L09 Cracks and L10 Cracks divided by column M "chip weight". I tried IF(AB:AB="L09 Cracks",SUMPRODUCT(AC:AC,AN:AN)/SUM(AM:AM). I cannot get any kind of formula to work, either from N/A messing it up or it not reading the criteria correctly.pqm-example.xlsx