Hi, so I used the formula =AVERAGEIF(L2:L1000, ">10", G2:G1000) to calculate the average of my data, however, excel shows an error saying "AVERAGEIF caused a divide by zero error". But, when i tried =AVERAGEIF(L2:L1000, "11", G2:G1000) it did work. Does anyone know what went wrong? I'm kind of confused. Thanks!