I am looking to average percentages in column L2:L3975 based on their criteria in C2:C3975. The criteria are raw material, packaging, and finished good. So what I am trying to do is track the accuracy of my inventory based on these 3 categories. Currently I have =IF(WSK!C2:C3975="Raw Material", AVERAGE(WSK!L2:L3975), ""). I think my logic is incorrect and have been trying a sumproduct formula but have not had results yet. If anyone has suggestions on how to average my percentages based on a text that would be very helpful. If examples are needed I can upload a spreadsheet.Thanks.